Hello,
I got the following code by recording a macro which fills a cell in a table, using a cell located in another worksheet, within a pivot table.
"=GETPIVOTDATA(""No of Tickets"",'[First Level Resolution.csv]IPVPN 1st Level'!R12C3)"
I need to convert the R12C3 to a dynamic cell and have located that cell dynamically and set it as x.
Any ideas as to how I can change the formula to use x instead of R12C3? Have tried different options with no luck.
Any help is appreciated. Thanks.
Last edited by VoodooChild; 05-12-2010 at 03:36 AM.
Is x a Range object or its address?
Remember what the dormouse said
Feed your head
Hi,
I think it's a cell address, but not 100%. Here's the code I'm using to get the address which has worked successfully in other instances.
Please Login or Register to view this content.
Where does x get set in that code?
Sry just said x in the beginning to make things simpler. Have actually set it as TTLIncCell and that's what I was trying to replace RC with.
You would use:
Please Login or Register to view this content.
Many thanks for that!
Could be here all night trying combinations and wouldn't have gotten it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks