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
|