Help on running two code auto when opening Excel workbook
Closed
Saeed1373
Posts
1
Registration date
Tuesday August 2, 2016
Status
Member
Last seen
August 3, 2016
-
Aug 3, 2016 at 08:41 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 9, 2016 at 11:32 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 9, 2016 at 11:32 AM
Related:
- Help on running two code auto when opening Excel workbook
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Battery reset code - Guide
- Facebook auto refresh - Guide
- Grand theft auto iv download apk for pc - Download - Action and adventure
- Samsung volume increase code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Aug 9, 2016 at 11:32 AM
Aug 9, 2016 at 11:32 AM
Hi Saeed1373,
Well, you can basicly put them beneath each other or try something like this:
Best regards,
Trowa
Well, you can basicly put them beneath each other or try something like this:
Private Sub Workbook_Open() Dim rng, InputRng, DeleteRng As Range Dim DeleteStr As String Sheets("Incident").Select TaskSheet: Set InputRng = ActiveSheet.Range("I:I") DeleteStr = "aaa" For Each rng In InputRng If rng.Value = DeleteStr Then If DeleteRng Is Nothing Then Set DeleteRng = rng Else Set DeleteRng = Application.Union(DeleteRng, rng) End If End If Next DeleteRng.EntireRow.Delete If ActiveSheet.Name = "Incident" Then Sheets("Task").Select GoTo TaskSheet End If End Sub
Best regards,
Trowa