Nothing to stop you from looping through the data and getting the
information you need.

also use the find method of the range object. See Excel VBA help for
details

--
Regards,
Tom Ogilvy


"pikapika13" wrote
in message ...

I looked into GetPivotData, but that will only give me the subtotals. I
have text (instead of numbers) that need to be selected (to be copied
somewhere else later).


--
pikapika13
------------------------------------------------------------------------
pikapika13's Profile:
http://www.excelforum.com/member.php...o&userid=10892
View this thread: http://www.excelforum.com/showthread...hreadid=527236