addendum to above:
my worksheet has no pivot tables, the last cell is NOT cell #500 (the last
cell is the 'correct' last cell)
(this is written as a clarification to earlier responses to a similar
question)
thanks all
steve