I am trying to copy one specific cell in a pivot table. Below is what I have, but it is getting hung up on the final line with a run-time object-defined error. Why am I getting this error?
Note: The range names in the pivot table were copied directly from the pivot table, so they are guaranteed to be accurate.
Please Login or Register to view this content.
There doesn't appear to be a destination for the copy.
Unless it's Range("H27") and there's a typo.
If posting code please use code tags, see here.
It is supposed to paste the value to Range("H27"). Where is the typo? If it's the space after Range, VBA is automatically adding that when I hit enter
Last edited by Gard5096; 01-30-2013 at 04:00 PM.
This is all one long statement, apart from ("H27").
There should be space between Copy and .Range("H27").Please Login or Register to view this content.
Please Login or Register to view this content.
Ok so now it is giving me a new error "Object Required". Do you think I need to use something like:
...athogh this gives me an error as wellPlease Login or Register to view this content.
To be honest I'm not sure what you need exactly, not really used this method to get a value from a pivot table
One thing you should probably do is split that line of code up and use a range variable.
This way you can check which part is actually causing the error.Please Login or Register to view this content.
I think it might be worth attaching a workbook.
I have attached a sample. I really just want to copy the value from a single cell in a pivot table, and paste it in a different location.
Try this.
Please Login or Register to view this content.
Norie, I was still having problems because there are actually multiple column headers. I found that using the intersect method worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks