Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass Info Between Macros (Re-Visited)
Hello, The last time I posted this question the Suggestion didn't work and I
didn't get much more help so I'm re-asking for help. 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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How days since last visited | Excel Worksheet Functions | |||
How do I pass info from excel to a hyperlinked explorer page | Excel Programming | |||
Using Multiple User Forms to pass info from one to the other | Excel Programming | |||
Pass multiple parameters through macros | Excel Programming | |||
How to pass variable value between macros | Excel Programming |