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
|