I recorded this simple macro with the following keystrokes.
When I enter these keystrokes it am placed in the first empty cell in the column, which when I recorded this macro was B109.
But when I run the macro it seems to always go to 109.
Why is that "range" specified in the macro? I thought that a keystroke; as in the down arrow, was recorded as a keystroke; not as a range, yet it appears that my down arrow assigned a range to the action.
How do I record just the keystroke; without causing that action to specific the cell it last caused the cursor to move to?
I thought maybe this issue was related to "Use Relative References" but clicking that option doesn't toggle it to "Use Absolute References".
I also found that I can only save macros as Ctrl +; there is no option available for Ctrl-Alt combinations, so it's hard to find a shortcut key combination that isn't already in use by XL.
The shortcut keystroke options may be a moot point as I am in about to upgrad to 2010 and that version may have the Ctrl-Alt option; I just thought I'd fire this off before I started.