Hi - I want to be able to find pivottable names for a group of pivots
on a worksheet. The idea being that I can then create a loop and do
"something" to each table.

i.e. for ii = 1 to 20

pname="pivottables"&str(ii)

do thing

next ii

Thanks Andrew