Run Macro only on Certain Worksheets

[hazza147]

Hi,

I have a Macro which is designed to run only through certain worksheets. However I need the Macro to also run on copied Worksheets without the need to update the Global Update Macro with the new Sheet Numbers/Names to run the code through.

At the moment I am trying to use a Named Range I.e. RFModulesIdentifier and the idea being the Macro looks for this named range on each Worksheet and if it doesn't find it for it to move onto the next Worksheet and look for this named range. Please view my current macro below and advise of any possible changes:

Please Login or Register  to view this content.

Any advice will be greatly appreciated!

Many thanks,

Harry Seager

[royUK]

Yor code appears to work on all sheets & there is no need to activate the sheets

[Marcol]

Another approach maybe?
This should only trigger your macro "PricelistChange_RF" on the sheets and copies where the name "RFModulesIdentifier" exists.
This only searches the names in the workbook, i.e. not every sheet.

I have activated the sheets as they are found because I don't know what your macro refers to. (ActiveSheet or Specified Sheets.)

Please Login or Register  to view this content.

Hope this helps