Hi,
I'm getting an error when trying to hide rows. I have highlighted the line that it stops on.
ThanksPlease Login or Register to view this content.
Hi,
I'm getting an error when trying to hide rows. I have highlighted the line that it stops on.
ThanksPlease Login or Register to view this content.
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
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.
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
Last edited by MP1286; 02-06-2017 at 01:59 PM.
I looked. I don't see what the problem could be.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks