D
dmcgimpsey
Hi Folks
I need the ability to position the active cell to the top left han
corner of the pivot table. Pivot tables are all named PivotTable1
The reason for this is that I refresh around 30 pivot tables each mont
through a macro, and unless I manually leave each worksheet with th
active cell position on a PT, I get an error, such as property no
supported for this object. I would like an automatic way to positio
the cell to the PT, without having to do it manually.
Thanks in advance,
Do
I need the ability to position the active cell to the top left han
corner of the pivot table. Pivot tables are all named PivotTable1
The reason for this is that I refresh around 30 pivot tables each mont
through a macro, and unless I manually leave each worksheet with th
active cell position on a PT, I get an error, such as property no
supported for this object. I would like an automatic way to positio
the cell to the PT, without having to do it manually.
Thanks in advance,
Do