Jun 14, 2010 #1 DanKay1 Programmer Joined Jun 9, 2004 Messages 54 Location US Is there a PivotTable function or solution which returns starting location of each pivottable in the worksheet? Thanks, Dan.
Is there a PivotTable function or solution which returns starting location of each pivottable in the worksheet? Thanks, Dan.
Jun 14, 2010 #2 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US Hi, Take a look at the PivotTable TableRange1 & TableRange2 properties. Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
Hi, Take a look at the PivotTable TableRange1 & TableRange2 properties. Skip, Just traded in my old subtlety... for a NUANCE!
Jun 14, 2010 Thread starter #3 DanKay1 Programmer Joined Jun 9, 2004 Messages 54 Location US Thanks it worked. One more question. Is there a way to get the first column position within pivot table? Thanks for your help. Upvote 0 Downvote
Thanks it worked. One more question. Is there a way to get the first column position within pivot table? Thanks for your help.
Jun 14, 2010 #4 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US PivotColumns Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote