Hi,
I have two macros set up to automatically refresh pivot table on two separate worksheets. The code for the first is: -
The first one runs fine but when I run the second one it falls over at the 'Range("B1")'Select of the first. It'sis probably something very simple that I am doing wrong but I can't for the life of me work it out. Can anyone help?
Please Login or Register to view this content.
Thanks in advance.
Alan.
what is sub RHide doing?
Looks like it is triggering the change macro in your other sheet
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Kev,
RHide is hiding rows that have no content...
Please Login or Register to view this content.
Last edited by Theangelp; 05-08-2017 at 04:29 AM.
Please edit previous thread and move "[/" to correct place to make the code tags work
I am guessing that Private Sub RHide is in the other sheet module
If you move it to a general module, then VBA will run the sub against the active sheet each time
(If you place a sub in a sheet module it always uses that sheet as its target unless you specifically refer to another sheet)
Hi,
I don't see why you need to select B1 at all. Wouldn't this suffice
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
RHide is in the second sheet module. I've moved it to Module1 but still getting the same error.
Thanks.
Thanks xl, that's worked a treat.
Xlnitwit is correct. You do not need to select "B1" - removing it will stop the VBA error.
But note my previous comment - if you want "Hide" to work for any sheet then move it to a GENERAL module otherwise you will need a copy of the sub in EVERY sheet module
Thanks Kev.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks