Thanks for the reply. Is there a way of telling which columns a pivot
table is using? I don't want to have to hardcode the column.

Andee