Macro worksheet names

texasalynn · May 20th, 2002, 02:39 PM

Is there a way to change a macro so that is doesn't have the actual worksheet file name. I want to use the same macro in different files but for now I have to manually edit the macro to change the filename.

I know someone will know - your help is greatly appreciated.

Al Chara · May 20th, 2002, 02:42 PM

You can do an Edit|Replace and replace it with a variable name of your choice and then set the variable to the different names of the different worksheets.

WayneTN · May 20th, 2002, 02:57 PM

See also........

http://www.mrexcel.com/board/viewtop...c=8285&forum=2

........for a similar post.

Thanks,
Wayne

May 20th, 2002, 02:42 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can do an Edit\|Replace and replace it with a variable name of your choice and then set the variable to the different names of the different worksheets. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 02:39 PM	#1
texasalynn Board Regular Join Date: May 2002 Location: Houston, TX Posts: 7,184	Is there a way to change a macro so that is doesn't have the actual worksheet file name. I want to use the same macro in different files but for now I have to manually edit the macro to change the filename. I know someone will know - your help is greatly appreciated.

May 20th, 2002, 02:57 PM	#3
WayneTN Board Regular Join Date: May 2002 Location: Tennessee, USA Posts: 72	See also........ http://www.mrexcel.com/board/viewtop...c=8285&forum=2 ........for a similar post. Thanks, Wayne