Peter T Wrote:
The whole point was NOT to copy or cut the whole sheet, otherwise will
transfer the same problem. However the fact you have and now find th
UR on
the newly pasted sheet is very large suggests something was wrong o
the
original sheet.

Select A1
Ctrl-Shift-End ' should select A1:BR568
Cut

Regards,
Peter T


interesting. what is the equivilant of ctrl-shift-end in VBA

--
drdavidg
-----------------------------------------------------------------------
drdavidge's Profile: http://www.excelforum.com/member.php...fo&userid=3616
View this thread: http://www.excelforum.com/showthread.php?threadid=56110