Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Global Variable -- Excel / VBA
I currently have a module in VBA that has 6 macros in it. In the third macro
I search down a column that was populated in the second macro. When I encounter an empty row, I go back up one row and call that row ticker_end (ticker_end = ActiveCell.Row). However, when I got to macros 4-6 they don't recognize ticker_end and I have to search through the column again for the condition I want and re-name the variable at the start of each macro. Considering that I can't create the variable before macro 3 because it depends on actions in macros 2, is there some way once I do set ticker_end I can make it keep its value through macros 4-6? Thank you |
#2
|
|||
|
|||
dim ticker_end as long
: sub macro2() : end sub sub macro3() : ticker_end = ActiveCell.Row : end sub sub macro4() : msgbox ticker_end : end sub Regards Trevor "Adam1 Chicago" wrote in message ... I currently have a module in VBA that has 6 macros in it. In the third macro I search down a column that was populated in the second macro. When I encounter an empty row, I go back up one row and call that row ticker_end (ticker_end = ActiveCell.Row). However, when I got to macros 4-6 they don't recognize ticker_end and I have to search through the column again for the condition I want and re-name the variable at the start of each macro. Considering that I can't create the variable before macro 3 because it depends on actions in macros 2, is there some way once I do set ticker_end I can make it keep its value through macros 4-6? Thank you |
#3
|
|||
|
|||
Trevor,
Thanks for your reply. I put in "msgbox ticker_end", but it just gave me a message box and then still didn't recognize ticker_end. I'm sure I'm missing something simple in your response, but if you help me a little more I'd appreciate it. Thanks, Adam "Trevor Shuttleworth" wrote: dim ticker_end as long : sub macro2() : end sub sub macro3() : ticker_end = ActiveCell.Row : end sub sub macro4() : msgbox ticker_end : end sub Regards Trevor "Adam1 Chicago" wrote in message ... I currently have a module in VBA that has 6 macros in it. In the third macro I search down a column that was populated in the second macro. When I encounter an empty row, I go back up one row and call that row ticker_end (ticker_end = ActiveCell.Row). However, when I got to macros 4-6 they don't recognize ticker_end and I have to search through the column again for the condition I want and re-name the variable at the start of each macro. Considering that I can't create the variable before macro 3 because it depends on actions in macros 2, is there some way once I do set ticker_end I can make it keep its value through macros 4-6? Thank you |
#4
|
|||
|
|||
Adam
you need to define the field once and once only ... before all the code. Check to see if you still have a dim statement in one or more of the modules. If you have, that will over-ride the global definition. Regards Trevor "Adam1 Chicago" wrote in message ... Trevor, Thanks for your reply. I put in "msgbox ticker_end", but it just gave me a message box and then still didn't recognize ticker_end. I'm sure I'm missing something simple in your response, but if you help me a little more I'd appreciate it. Thanks, Adam "Trevor Shuttleworth" wrote: dim ticker_end as long : sub macro2() : end sub sub macro3() : ticker_end = ActiveCell.Row : end sub sub macro4() : msgbox ticker_end : end sub Regards Trevor "Adam1 Chicago" wrote in message ... I currently have a module in VBA that has 6 macros in it. In the third macro I search down a column that was populated in the second macro. When I encounter an empty row, I go back up one row and call that row ticker_end (ticker_end = ActiveCell.Row). However, when I got to macros 4-6 they don't recognize ticker_end and I have to search through the column again for the condition I want and re-name the variable at the start of each macro. Considering that I can't create the variable before macro 3 because it depends on actions in macros 2, is there some way once I do set ticker_end I can make it keep its value through macros 4-6? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |