Macro problems
When you record a macro, Excel picks up all the details: where is the
cell pointer located, etc, and assumes you want to replicate that each
time. Most likely your macro has a row in it that says something like
Range("A1").Select, which is where you were when you recorded.
To fix it, save your working file and work from a backup copy so you
don't lose data. Open the file; on the menu click Tools Macro
Macros and highlight the macro you recorded; press Edit. The Visual
Basic editor opens, and shows you the instructions you recorded. Near
the top there will likely be a Range("A1").Select command. You can
delete it, or enter an apostrophe before that command, which signals
the compiler to disregard that row.
Good luck with it!
Dave O
Eschew Obfuscation
|