I have come across a strange problem with Range.Find() and wonder if anyone
has heard of it and may have a solution.
I have a worksheet containing a pivot table. To the right of the pivot is an
area that calculates further information from the pivot values. The rows in
this right-hand area are keyed in one column by a combination of data from
the pivot (essentially a combination of the pivot categories). The columns in
the right-hand area are keyed by fixed symbolic names in row 1.
I am using the range.find method to locate a particular column and row using
a find across row 1 and a find down the row key column.
My problem is that the find does not work, and investigation shows that
although it works on all the columns up to the last column of the pivot
table, in the area to the right of the pivot table it does not work (at
least, it cannot match any values but, bizarrely, it can match an empty cell
using .find(""). In all other cases the find returns Nothing).
If anyone can suggest a solution or simple workround, I would be very
grateful.
John