MrExcel Publishing
Your One Stop for Excel Tips & Solutions

want a macro to run on only one worksheet?

Posted by Rich B on October 30, 2000 12:02 PM

I have a macro that I want to run on only one worksheet. I have two workisheets in the workbook. I only want the macro to run in the second worksheet. I also wnat it to aout open. How can i do this?

Posted by Ivan Moala on October 31, 2000 12:07 AM

What ever your code is that runs.....if it works
on a specified range then take it a step back
and define the range by specifyiing the sheet name. or Activating that particular sheet.
eg. Sheets("mysheet").activate.....

or Sheets("mysheet").Range("A1:A10")= do something

If you have specifics then post....