View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson[_2_] Myrna Larson[_2_] is offline
external usenet poster
 
Posts: 124
Default Stattic Variable

Another option is that if you want the numbers to start with, say, 10, just add 10 to the
reported value.


On Tue, 2 Sep 2003 21:32:48 -0700, "Lee" wrote:


<<sorry. Shld have posted my message here instead of the
General section

Hi! Friends.

Can someone help:

I wish to preserve the value of a variable (say n) each
time I run the procedure, I have:

Sub count()
Static n as integer

n=n+1

end sub

May I know how I can start with an initial value of n
other than 0. I use CALL sub, but doesnt work.

Many thanks.
.