Passing Info Between Macros
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
|