How can I get my Macro to set a range when it moves to a new sheet

[Mr House]

Hi All,

Disclaimer - New to coding.

I have a macro which scrolls through all sheets in a workbook and does "X". However I require a range to be re-set on each sheet, I can't get this to work.
It appears that the macro is changing sheets but not moving the range of cells to do the action on, I.E. the process reoccurs on the first sheet in the workbook only

The part of the code which I can't get right is in Bold.


Any help would be awesome.
[INDENT]

Please Login or Register  to view this content.

[Hydraulics]

Change the instruction to

Please Login or Register  to view this content.

so that you are formatting each Sheet in the collection and not only the Active one.

[Mr House]

Thank you for your reply,

I actually had that originally, same problem.

Regards
Mr House

[Mr House]

Solved this :D