|Please forgive me if this has already been answered, but I didn't find what I'm looking for.|
I'm trying to figure out why in excel 2007 when I record a macro that does simple things such as delete rows, columns, and sorts, that macro will tag itself to a particular worksheet / file and not stay generic.
By that I don't mean that I am saving the macro so that it only works for that one file, but that even though the macro is accessible in any excel document I open, it will not work because the select range references the file / workbsheet that the macro was created in.
When I used to create macros in excel 2003, it would select a range and that range would work in any excel document I opened.
I hope this makes sense, and that someone can help me with this.
Thank you very much.