CTRL+G

[Zac]

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?

 

[Greg Truby]

You can copy a selection of non-contiguous cells as long as each area has the same column(s). You can't cut like that. Try copying then depending on your desired outcome, .ClearContents; .Clear or .Delete Shift:=xlUp back in your source range.