I have attached a worksheet that is driving me crazy. The code that I am using is listed below:
I know this code works because I have used it many, many times and it gives the pivot results I am looking for. I really don't know what the problem is here. Any thoughts are welcome.HTML Code:
Thanks
Eddie
Last edited by punter; 09-03-2014 at 11:25 AM.
I suspect the error is in named range.
If I change this line
INTO
Please Login or Register to view this content.
it works.Please Login or Register to view this content.
It know PT will not work if you have a complete blank rows or columns, but could not see this problem on your data.
Last edited by AB33; 09-03-2014 at 11:12 AM.
this seems to work also
CHANGE
INTOPlease Login or Register to view this content.
EDIT: just a note....I commented out the On Error stuff because it was masking errors....HTHPlease Login or Register to view this content.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Thank you for your quick reply.
If I force the range to be A7:F1614 won't I have to update that every time I change the source data?
Thanks
This seems to have worked. Thanks so much.Originally Posted by judgeh59
this seems to work also
CHANGE
INTOPlease Login or Register to view this content.
EDIT: just a note....I commented out the On Error stuff because it was masking errors....HTHPlease Login or Register to view this content.
Eddie
glad I could help....and thanks for the rep points
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks