Hello experts,
I have challenge for you.
thank you for help in advance.
Based on number of selected rows I would like to do specific multiplying of same macro step by step, connected to start row and end row.
For example:
I have selected "D2:D3" - then after clicking to macro button I would like to do:
due to the D2 marking:
Activate D2 row:
Sheets("List1").Range("K" & ActiveCell.Row) = Date
Macro 1
Macro 2
wait for ending of Macro 2, then can start next action:
due to the D3 marking:
Activate D3 row
Sheets("List1").Range("K" & ActiveCell.Row) = Date
Macro 1
Macro 2
End..
of course there can be marked one row, or 50 rows...
Thank you very much for help.
Actual code, Macro 1 and Macro 2 Msgbox as example:
Sub TEST()
Application.ScreenUpdating = False
Sheets("List1").Range("K" & ActiveCell.Row) = Date
Macro1
Macro2
End Sub
Sub Macro1()
MsgBox "hello 1"
End Sub
Sub Macro2()
MsgBox "hello 2"
End Sub
Bookmarks