Reference Active Sheet

[xjohnson]

Hello can the following code be altered so that wherever Sheet 3 is mentioned it refers to the active sheet instead?

Thank you very much

Please Login or Register  to view this content.

[vcoolio]

Hello XJ,

You've just about answered your own question!

Change Sheet3 to ActiveSheet.

This should allow you to run the procedure on any sheet.

I hope that this helps.

Cheerio,
vcoolio.

[xjohnson]

Thank you this way saves me time and also keeps it easier having only one code instead of 8 for my workbook.

[vcoolio]

You're welcome XJ.

I'm glad that I was able to help.

Cheerio,
vcoolio.