Looping through worksheets

[The Phil]

Hi,

I am trying to perform the same actions on all of the worksheets in my workbook. I have tried the following two codes but neither of them work:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I tried that last one with "next" and "next ws".

Neither of these are making all of the changes that are specified. Any thoughts?

Thank you.

[Sean Thomas]

whats not working?
is there an error? if so where is the error occuring?

[judgeh59]

maybe try adding ws. to the beginning of cells and ranges...

[Norie]

Try this.

Please Login or Register  to view this content.

[Sean Thomas]

what is Ryear? you dont have anything declared? is it a variable?
if it cant find it, it will error or ignore the code

[JOHN H. DAVIS]

Is RYear specified in each sheet or do you need to reference a value from a specific sheet?

Please Login or Register  to view this content.

[The Phil]

Thank you all for responding.

I added the "ws.activate" line and that fixed it.

My problem is that the cells weren't being updated on each sheet. Now it is working with that extra line of code.

Thanks!!

[Haikal_]

It is now working
i have added:
Ws.Activate

the final working code is

Please Login or Register  to view this content.