+ Reply to Thread
Results 1 to 1 of 1

Error 1004 Hidden Property of Range Class???

  1. #1
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Error 1004 Hidden Property of Range Class???

    I posted this workbook a few days ago and have since made a few clean-ups on it. I am still getting a "Error 1004:Unable to set the Hidden Property of the Range Class" error message when I select any of the ListBox items. When I click to Debug this part of the code is highlighted:

    Please Login or Register  to view this content.
    When I close the VBA editor rows 4:393 are hidden. Once I unhide them the desired rows are showing and the undesired are hidden. So I am wondering if there is a setting or such that I need to correct?

    One respondent told me this workbook performed fine on his Mac but I'm using Excel 2010 on a PC. He indicated that my error may have to do with ActiveX Controls, but since this same code works in another workbook I don't think that's the issue.

    Very perplexing! Anyone have any ideas? Thanks. David
    Attached Files Attached Files

+ 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. Error 1004: Unable to Set Hidden property of the range class...
    By jaysakle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2013, 02:51 AM
  2. [SOLVED] Run time error 1004: Unable to set hidden property of range class
    By SAVIOBLUEFOX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2013, 10:38 AM
  3. [SOLVED] Runtime error 1004: Unable to set the hidden property of range class
    By Loobrush in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2013, 05:18 AM
  4. Help Please w/ Run-time error '1004' Unable to set the Hidden property of the Range Class
    By ExcelNewbie2534 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2012, 07:38 PM
  5. Error 1004 (unable to set the hidden property of the range class)
    By alex.heng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2011, 12:45 AM
  6. Run-time error 1004: Unable to set the hidden property of the Range class.
    By seabee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2011, 05:09 PM
  7. Error 1004 Unable to set the Hidden Property of the Range Class
    By nld in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2007, 10:56 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