Happy2Learn
Board Regular
- Joined
- Jul 28, 2004
- Messages
- 68
Hi Excel'rs.
My macro's started to halt with the Error 'Runtime Error 1004' Cannot use that command on overlapping selections. Problem is I'm not sure I am selecting overlapping selections.
Here's the offending code.....
Sheets("temp").Select
Range("A4:A" & Range("A65536").End(xlUp).Row).Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
Range("A3").Select
This selects all on column A from A4 to the bottom, does a goto blanks and deletes entire selected row.
This has worked in the past and I'm not sure what would cause this error.
Any thoughts?
Hope you can help!
My macro's started to halt with the Error 'Runtime Error 1004' Cannot use that command on overlapping selections. Problem is I'm not sure I am selecting overlapping selections.
Here's the offending code.....
Sheets("temp").Select
Range("A4:A" & Range("A65536").End(xlUp).Row).Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
Range("A3").Select
This selects all on column A from A4 to the bottom, does a goto blanks and deletes entire selected row.
This has worked in the past and I'm not sure what would cause this error.
Any thoughts?
Hope you can help!