Can't resolve PivotTable Property error.
I am trying to use the following code...
I keep getting an error relating to PivotTable Properties when the codes gets to this portion of the code...
Please Login or Register to view this content.
And I am going nuts trying to resolve. Can anyone please give me some insight or assistance to resolve this issue?Please Login or Register to view this content.
What is actual error?
I will suggest you continue to use PVT variable:
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
I was getting the following error....
"Run-time error '1004':
Unable to get the PivotTable property of the Worksheet class"
And I am getting that error every time the code gets to this portion...
So if I use your amended code, then that should resolve this issue?Please Login or Register to view this content.
You may try it and tell me.
Nice!!!
Awesome!!!! Thanks...it works like a charm now.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks