Tom,

The value I wish to format on is not on the active sheet. It is
field in the source row of the data. As far as I know, the only way
can view the value of that field is if I drill down, and a ne
worksheet opens with the row.

How would I reference the value of that field if it is not displayed o
the active sheet?

Thanks,
Stephe

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com