Perhaps you can share your code for comments

activesheet.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"scott" wrote in message
...
I am trying to create a macro that will perform the same function on
different tabs in a workbook, but whenever i try to run the macro for
various
tabs, the macro defaults to the original tab that the macro was created in
and I end up getting an error message with options to end, debug, or
cancel.
does anyone have suggestions to how i can fix this?