LinkBack URL
About LinkBacks
I can use this to select Data Labels:
or I can use this to select the full Rows which includes their labels:
pt.DataLabelRange.Select
How can I select the Row labels Only?pt.RowRange.Select
I can use this to select Data Labels:
or I can use this to select the full Rows which includes their labels:pt.DataLabelRange.Select
How can I select the Row labels Only?pt.RowRange.Select
Does this get what you want?
Intersect(pvtTable.DataBodyRange.EntireRow, pvtTable.RowRange).Select
Andy, thank you very much. It did not get me directly what I wanted (probably because I was not clear) but it gave me the conceptual thinking to figure it out on my own. Here is what did what I wanted:
Now I want to be able to loop through all those cells that get selected in that intersection. How can I do that? (the size of it will always be different so I cannot hard code an amount of loops.Intersect(pt.DataLabelRange.EntireRow, pt.RowRange).Select
dim rngCell as range for each rngCell in Intersect(pt.DataLabelRange.EntireRow, pt.RowRange).cells ' do stuff Next
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks