increment

Hi i would like to know how do i increment or add a value when doing a for loop.

eg. Dim i as interger.

i = formula for multiple pages.

so question is: how do i make sure that the value for every page is added to i

Hi

If you want to loop thru all the worksheets in your workbook, adding a specific cell's value to a variable, then a For Each Next loop is probably the best option eg:

Please Login or Register  to view this content.

This will add all the values in B4 together.

Richard

Hey this code might just work..

but the code is counting one cell per sheet. I would like to count the whole column for example A:A where the cell is a non blank.

is there a way??..thanks a lot.