Hi Geoff,

Norman - Debra Dalgeish's utility works fine and I can adapt this ok. But
it is just as important for me NOT to miss data as it is to make my
program
work more efficiently and when UsedRange showed last cell at AJ31954 I
became
concerned.

Is this extended range a 'feature' I should just accept?

Resetting the used range will not result in data loss - it will merely
reduce the used range to the minumum range which encompasses all data cells.

Is this extended range a 'feature' I should just accept?

Essentially, yes.

I have a macro assigned to a toolbar button so that I can readily reset the
used range of one or or more worksheets / workbooks


---
Regards,
Norman



"Geoff" wrote in message
...
Hi
Jim - No this is how the wsheet was presented to me by a.n.other. I took
it
as is and when I noticed how slow my utility was processing I decided to
investigate. Looking back, this has happened lots of times and I wondered
why.

Norman - Debra Dalgeish's utility works fine and I can adapt this ok. But
it is just as important for me NOT to miss data as it is to make my
program
work more efficiently and when UsedRange showed last cell at AJ31954 I
became
concerned.

Is this extended range a 'feature' I should just accept?

Geoff