global Variables

Why do my variable seem to not be global? I have two subs:

Sub A()
Static CountRows As Long
CountRows = 1
MsgBox (CountRows)
End Sub

This one shows that CountRows = 1

Sub Bt()
Static CountRows As Long
MsgBox (CountRows)
End Sub

But when I run this one it does not remember CountRows = 1, and resets it to
zero. Why?

You need to Dim you variable outside and before your Subs. This make them
"global".
--
Gary''s Student


"Mike" wrote:

> Why do my variable seem to not be global? I have two subs:
>
> Sub A()
> Static CountRows As Long
> CountRows = 1
> MsgBox (CountRows)
> End Sub
>
> This one shows that CountRows = 1
>
> Sub Bt()
> Static CountRows As Long
> MsgBox (CountRows)
> End Sub
>
> But when I run this one it does not remember CountRows = 1, and resets it to
> zero. Why?