Counting

[Mike]

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.

[Norman Jones]

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" <Mike@discussions.microsoft.com> wrote in message
news:7A52145E-F4BB-4561-8224-0BBC2374A274@microsoft.com...
> 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.

[Mike]

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" <Mike@discussions.microsoft.com> wrote in message
> news:7A52145E-F4BB-4561-8224-0BBC2374A274@microsoft.com...
> > 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.
>
>
>