Go through all worksheets not functioning

Hey guys, I'm trying to pull some averages from worksheets that are all formatted the same way. When I run the following I get the
"September
August
Past 12 Months" table at the bottom of the first worksheet (where I put the control button), but nothing on the other pages... Any idea why?

Please Login or Register  to view this content.

Thanks a lot,

C

Hi, clevot,

please have a read at Forum Rule#3 to understand why you are asked to add code-tags to your procedure.

Ciao,
Holger

You're not qualifying your Range calls with a worksheet and because your code is in a worksheet code module, all the unqualified calls refer to that sheet, not the active sheet. Try this:

Please Login or Register  to view this content.