Counting
 

How can I add something to a variable each time I run the macro? So
basically, I have a variable called CountRows, and each time I run the macro,
I want CountRows to increase by a certain number (different each time it is
ran). I just want it to keep a tally. So I have another variable called Rows.
I thought I could do the following:

CountRows = CountRows + Rows

Then the next time it is ran for a different sheet, it will remember what
was in CountRows and add the new Rows number to it.

Counting
 

Hi Mike,

One way, try something like:

'==============
Sub Tester02()
Dim iRows As Long
Static countRows As Long

iRows = Cells(Rows.Count, "A").End(xlUp).Row
countRows = countRows + iRows

End Sub
'<<==============


---
Regards,
Norman



"Mike" wrote in message
...
How can I add something to a variable each time I run the macro? So
basically, I have a variable called CountRows, and each time I run the
macro,
I want CountRows to increase by a certain number (different each time it
is
ran). I just want it to keep a tally. So I have another variable called
Rows.
I thought I could do the following:

CountRows = CountRows + Rows

Then the next time it is ran for a different sheet, it will remember what
was in CountRows and add the new Rows number to it.

Counting
 

THANK YOU!

"Norman Jones" wrote:

Hi Mike,

One way, try something like:

'==============
Sub Tester02()
Dim iRows As Long
Static countRows As Long

iRows = Cells(Rows.Count, "A").End(xlUp).Row
countRows = countRows + iRows

End Sub
'<<==============


---
Regards,
Norman



"Mike" wrote in message
...
How can I add something to a variable each time I run the macro? So
basically, I have a variable called CountRows, and each time I run the
macro,
I want CountRows to increase by a certain number (different each time it
is
ran). I just want it to keep a tally. So I have another variable called
Rows.
I thought I could do the following:

CountRows = CountRows + Rows

Then the next time it is ran for a different sheet, it will remember what
was in CountRows and add the new Rows number to it.