multiple sheets

[nyn04]

I have multiple worksheets with randon names, how would I write a cod
to run through every sheet performing calculation, for example I hav
50 sheets and I will like to add up all the cell A1 of everysheet,

I need to do this in VBA, and the sheets have assigned names such as
BLM, GLO etc...

thank

 

[Jim Rech]

One way:

MsgBox Evaluate("SUM(Sheet1:SheetX!A1)")

where Sheet1 is the first worksheet and SheetX the last.

--
Jim Rech
Excel MVP
|I have multiple worksheets with randon names, how would I write a code
| to run through every sheet performing calculation, for example I have
| 50 sheets and I will like to add up all the cell A1 of everysheet,
|
| I need to do this in VBA, and the sheets have assigned names such as,
| BLM, GLO etc...
|
| thanks
|
|
| ---
| Message posted
|