Hello vba Experts,
The purpose of my vba module is to find rows with blank cells and then delete the row with the blank cell. Code pasted in attached text.
When run, vba returns: Run Time Error 1004: Cannot Use Command on overlapping selections. The error occurs on the line calling for deleting the specified row. I have identified that the error is coming from the ?Item? column (Column F, see attached spreadsheet). I tried copying and pasting the format from the ?Name? column (Column G), to no avail. I know that the ?Item? column is the culprit because when I delete that column the code runs fine. I have real data with thousands of lines so I really need to get the code working or source of error fixed. Thank you.
Bookmarks