Having trouble looping through sheets

[EverGreen1231]

I need to loop through the sheets in my workbook and alter Cell (1, 1). That's it. It's should be simple, but I can't get the code below to run past whatever sheet happens to be active at that moment. Any ideas why this might be?

Here's my code snippet...

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[EverGreen1231]

Try this.

Please Login or Register  to view this content.

It works! Thank you.

If you have time, could you explain why my code didn't work as intended?

[EverGreen1231]

Hmmm, though the above script works in that specific instance, I can't seem to get the loop to work with a more complex script such as that below...

Please Login or Register  to view this content.

I tried a dirtier way by importing the individual sheets names into an array and then looping through the array and selecting the name of the sheet that corresponds to the respective array index, but this give a runtime error '9' where the subscript is out of range. I can't figure out why.

Here's that code...

Please Login or Register  to view this content.

[Norie]

In your code Columns and Rows don't reference a specific sheet, so they refer to the active sheet.

What you need is a With statement and a couple of dots.

Please Login or Register  to view this content.