Copy Range in a Pivot Table

[Gard5096]

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.

[Norie]

There doesn't appear to be a destination for the copy.

Unless it's Range("H27") and there's a typo.

[Gard5096]

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

[Norie]

This is all one long statement, apart from ("H27").

Please Login or Register  to view this content.

There should be space between Copy and .Range("H27").

Please Login or Register  to view this content.

[Gard5096]

Ok so now it is giving me a new error "Object Required". Do you think I need to use something like:

Please Login or Register  to view this content.

...athogh this gives me an error as well

[Norie]

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.

Please Login or Register  to view this content.

This way you can check which part is actually causing the error.

I think it might be worth attaching a workbook.

[Gard5096]

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.

[Norie]

Try this.

Please Login or Register  to view this content.

[Gard5096]

Norie, I was still having problems because there are actually multiple column headers. I found that using the intersect method worked great.