I replaced Global vcol1 as Integer
with
Public vcol1 as Integer

but as soon as I run my macro in my Standard Module and I go to the immediate
Window and enter ? vcol1 and <return
I get 0, versus say 9



"Otto Moehrbach" wrote:

Use:
Public vcol1 as Integer
"Jim May" wrote in message
...
If in a standard module I have an interger variable and I wish to be able
to
use this variable later in a sheet_change event, what exactly would I do?
Above the Standard module I put:

Global vcol1 as Interger

But I'm not sure what else I am to do in order to have it later to use in
my
Sheet_Change event code.