I'm trying to record a MACRO that shows the non-blank cells in COL "D".
Then I want to hit CTRL+G, Special, Visible Cells Only, and cut them to another location.
I've performed this before in a MACRO, but I'm getting an error this time
which states:
"The command you chose cannot be performed with multiple selections.
Select a single range and click the command again".
Like I said I've done this before and use this command for my Acctg Dept for their end of the month Commission Report.
Why can't I do it here?
Then I want to hit CTRL+G, Special, Visible Cells Only, and cut them to another location.
I've performed this before in a MACRO, but I'm getting an error this time
which states:
"The command you chose cannot be performed with multiple selections.
Select a single range and click the command again".
Like I said I've done this before and use this command for my Acctg Dept for their end of the month Commission Report.
Why can't I do it here?