Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a Dim that us the same in multiple macros shown below
Dim RowID RowID = ActiveCell.Row How do I use the same RowID in the Original Sub and when it's done running it passes the same value of RowID to the next sub? Originating Sub - InsertSection() 2nd Sub - SetBorders() 3rd Sub - InsertFormulas() 4th Sub - AddText() 5th Sub - SetColors() 6th Sub - ConditionalFormatting() 7th Sub - SetNames() There's more but you get the point. All of them start off with the very same Dim shown above and they all end with the same Range Selection Range("A" & RowID).Select Any help would be awesome. Thanks in Advance. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing Excel Info To Visio | Excel Discussion (Misc queries) | |||
Passing info from macro to UserForm | Excel Programming | |||
Passing the Name of a Control Between Macros | Excel Programming | |||
Passing Macros Between Workbooks | Excel Programming | |||
passing value with button to macros | Excel Programming |