How do you get the start and end columns on which a pivot table spans/is plotted? Essentially I need these to correctly position the pivot tables.
With functions such as pivotTable.TableRange I am able to see the column and row indices such as 6, 2 but I can also see something like B10:G12 i.e. actual Excel column headings (which is exactly what I want) but I can’t find any way of extracting these Excel headings!
Thanks. I have solved this problem by implementing the following method: