Static Variable

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

Hi! Friends.

Can someone helps:

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.
 
Hi! McGimpsey

Really appreciate your enormous helps. I will try out your
suggestions.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stattic Variable 4
Problems with worksheets 1
Insert row on multiple sheets 6
date format static 5
Error 381 8
Alphabetize Tab & Toc's Hyperlink 7
Help using Chip Pearsons code to count cells with color 9
Set chart series endpoint dynamically 0

Back
Top