Results 1 to 27 of 27

Run Time Error 1004: Cannot Use Command on overlapping selections

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2019
    Location
    United State
    MS-Off Ver
    2019
    Posts
    53

    Run Time Error 1004: Cannot Use Command on overlapping selections

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Named ranges & error 1004 "cannot use that command on overlapping sections....
    By locolobo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2022, 07:21 AM
  2. Replies: 10
    Last Post: 11-10-2021, 09:49 AM
  3. Error: Cannot use that command on overlapping selections. Please help
    By ufondu88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2018, 12:35 PM
  4. Run-time error 1004: this action won't work on multiple selections
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-08-2018, 12:50 PM
  5. [SOLVED] Runtime 1004 Error - Cannot Use that Command On Overlapping Sections
    By stevoDE in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-13-2017, 11:18 AM
  6. [SOLVED] Run-time error '1004' when executing Exit Sub command line
    By Henk Stander in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-29-2014, 02:50 AM
  7. Run Time Error 1004 - You cannot use this command on a protected sheet
    By frogboy in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-11-2012, 07:59 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1