ExcelBanter - View Single Post

try sheet7.etc

--
Don Guillett
SalesAid Software

"jstoner50" wrote
in message ...

I have a macro that references the sheet tab name that I have given it.
The problem is these Tab names change periodically, And that means I
have to run a find and replace function to change my Macro with these
tab names with the new names. When I look at the module in the Macro
screen they show sheet1=(my Name). But what i need is to reference my
macro to the Excel default name sheet1, sheet2, sheet3,...etc. I hope
I explained my issue.

Thanks for any help

--
jstoner50
------------------------------------------------------------------------
jstoner50's Profile:
http://www.excelforum.com/member.php...o&userid=28651
View this thread: http://www.excelforum.com/showthread...hreadid=483154