Which line is highlighted it you click Debug after receiving the error?
Excel 2016 Error "1004"
I'm receiving the following error when trying to run a recorded macro:
"Run-time error '1004': Cannot use that command on overlapping selections."
It was successful when I recorded it, but when I tried to run it on a new sheet, I received the error. My code:
Sub Sub_and_delete_blanks()
Sheets("Innovation Mapping Project - Re").Range("A1:MX29").AdvancedFilter _
Action:=xlFilterCopy, CriteriaRange:=Range("A1:A2"), CopyToRange:=Range( _
"A5"), Unique:=False
Rows("5:7").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireColumn.Delete
End Sub
"Run-time error '1004': Cannot use that command on overlapping selections."
It was successful when I recorded it, but when I tried to run it on a new sheet, I received the error. My code:
Sub Sub_and_delete_blanks()
Sheets("Innovation Mapping Project - Re").Range("A1:MX29").AdvancedFilter _
Action:=xlFilterCopy, CriteriaRange:=Range("A1:A2"), CopyToRange:=Range( _
"A5"), Unique:=False
Rows("5:7").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireColumn.Delete
End Sub
- Status
- Not open for further replies.
1 - 2 of 2 Posts
1 - 2 of 2 Posts
- Status
- Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
