+ Reply to Thread
Results 1 to 6 of 6

Unable to set the Hidden property of the Range class

  1. #1
    Registered User
    Join Date
    10-06-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    20

    Unable to set the Hidden property of the Range class

    Hi,

    I'm getting an error when trying to hide rows. I have highlighted the line that it stops on.

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Registered User
    Join Date
    10-06-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    20

    Re: Unable to set the Hidden property of the Range class

    I have two other buttons on the same Worksheet which do the same thing but for different rows.

    I've realised that when one set of rows is hidden and I click another button, the run-time error appears.
    Last edited by MP1286; 02-06-2017 at 01:02 PM. Reason: Clarification

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Unable to set the Hidden property of the Range class

    Your code worked for me. I also duplicated the macro for other rows and it worked as well. Must be something else going on in the workbook.

    If you want to attach an example workbook that illustrates the problem, I'll take a look.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Registered User
    Join Date
    10-06-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    20

    Re: Unable to set the Hidden property of the Range class

    That would be much appreciated.

    I've attached a stripped down file for you and for some reason, I don't get the error at all. I've deleted a lot of the raw data and a pivot table tab. I really can't see why any of those would've caused this error?

    There is code in Worksheet 03-02-17 and Module 2. The buttons are on Status Update and 03-02-17. For some reason, the button below section 2 does not hide the correct range.

    Thanks again
    Attached Files Attached Files
    Last edited by MP1286; 02-06-2017 at 01:59 PM.

  5. #5
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Unable to set the Hidden property of the Range class

    I looked. I don't see what the problem could be.

  6. #6
    Registered User
    Join Date
    10-06-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    20

    Re: Unable to set the Hidden property of the Range class

    Thanks for looking. Is there anything else I should check?

    EDIT: So I removed some comments and objects and it seems to be working. That could've been the issue but I'll report back if I find anything else.
    Last edited by MP1286; 02-07-2017 at 06:56 AM.

+ 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. Unable to set the Hidden property of the Range class
    By crimzon in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-22-2014, 02:02 AM
  2. 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
  3. Unable to set hidden property of the Range class
    By Andrew Kennerley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2011, 04:34 PM
  4. Unable to set the hidden property of the range class - Column Hiding
    By chobson in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-19-2011, 10:40 AM
  5. Unable to set the hidden property of the range class
    By Christian411 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2009, 11:48 AM
  6. Unable to set the Hidden property of the Range class
    By luckycharm1668 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2007, 11:12 PM
  7. Unable to set the Hidden property of the Range class
    By Pedros in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2007, 08:47 PM
  8. [SOLVED] 1004 - Unable to set the hidden property of the range class
    By Tim Whitley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2006, 05:55 PM

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