macros run only on active sheets

Please Login or Register  to view this content.

I created the above code which i want to run on specific sheets but in stead it runs on the active sheet

Plz help

You need to add a Period before Range and Column references in order for them to be relative to the With statement

Please Login or Register  to view this content.