Hi,
How do extract data of particular pivot item using VBA. for ex. I need to extract data of
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible in the same worksheet. Thanks!
With pvt_tbl
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True...
Hi,
I am looking for a VBA code which removes object releated hyperlinks. I have nearly 200 objects in the worksheet.
Thanks in Advance.
Regards,
Chandrashekar B