In , Dave Peterson
spake thusly:

The macro won't be the cause. But if you put something in the
far right corner (say IV65536 to be extreme), then delete the
contents of that cell, you'll see the problem.

I believe that if you save the file after deletion of the
cell contents, the problem goes away.

In any case, I have a macro that looks for the bottom row.
In order to avoid those kinds of problems, I have the macro
save the file before it runs that particular statement.

==================================
Dallman Ross wrote: <<snipped

Sometimes excel's lastusedcell won't be what you expect it to
be.

I've occasionally found that out; yup! :-) (But so far, not
with this macro.)

Or visit Debra Dalgleish's site for some
techniques for resetting that lastusedcell.
http://www.contextures.com/xlfaqApp.html#Unused

Will do.

Dallman