Hi,

Please post some of your code so that potential helpers can see your
approach & we may be able to make some informed suggestions.

Btw, I don't know if it will be the case in this situation, but there
are other situations that work this way by design in Excel eg resetting
the last cell of the used range won't occur until the file is saved.
It may just be that you need to incorporate a line like
"activeworkbook.save" into your code.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=537362