If your sheet has some merged cells, things can act strangly when trying to
change the .UsedRange via code. Contextures has code to do it and to handle
sheets with merged cells:
http://www.contextures.com/xlfaqApp.html#Unused


"carl" wrote:

Hi Otto,

I think you've managed to kill two birds with one stone here. I've always
wondered why the range size is increased in certain sheets when it's obvious
that the range of my data is far smaller.

In the workbook that I'm having problems with there are 30 sheets and quite
a few of them have a range of roughly M65000. This is obviously one of the
problems. Can you please tell me how to get the range back down to the
correct size?