+ Reply to Thread
Results 1 to 3 of 3

Run Time Error 1004 after selecting cells with Data Validation.

  1. #1
    Registered User
    Join Date
    12-26-2016
    Location
    London, England
    MS-Off Ver
    365
    Posts
    79

    Run Time Error 1004 after selecting cells with Data Validation.

    Hi - I have a bit of a strange error that occurs only after a cell with some DATA VALIDATION is selected.

    Here is the code that runs on Cell Selection Change.

    Please Login or Register  to view this content.
    Here is the code that crashes after I select any cell with DATA VALIDATION in it. (Crashes on the code in BOLD)

    Hope someone can shed some light as to why? Everything works fine until I select a cell with Data Validation.

    Please Login or Register  to view this content.
    Last edited by hans302; 01-06-2017 at 01:26 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,607

    Re: Run Time Error 1004 after selecting cells with Data Validation.

    code tags updated
    Last edited by protonLeah; 01-06-2017 at 01:50 AM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-26-2016
    Location
    London, England
    MS-Off Ver
    365
    Posts
    79

    Re: Run Time Error 1004 after selecting cells with Data Validation.

    Thanks - I have corrected and posted again into the right section.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Receive a Run-time error '1004' when selecting a designated range of rows
    By blrunning in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2015, 08:52 AM
  2. Run-time error 1004 selecting range
    By Ray Sofio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2014, 04:55 PM
  3. Run Time Error 1004 when selecting range on another sheet using a command button
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 07:43 AM
  4. Run-time Error 1004 with Data Validation
    By RagonichaFulva in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2012, 07:47 AM
  5. Error 1004 when selecting a range of cells
    By isrisian in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2011, 07:01 PM
  6. 1004 error with data validation
    By geoB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2010, 09:31 AM
  7. [SOLVED] Merge Cells run-time error '1004'
    By darxoul in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2006, 10:10 AM

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