Excel gets hungup when Copy Paste
 

In VBA. whenever I am copying a large 10000+ row worksheet and pasting a
copy of it in a new sheet, excel gets hungup, eventually it will
continue, sometime it will not. Even the "Create a copy" function when
right clicking on the sheet hangs up. Is there another way to copy the
whole sheet in vba that runs more quickly??
Hung up,
Mike.



*** Sent via Developersdex http://www.developersdex.com ***

Excel gets hungup when Copy Paste
 

are you copying formulas?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=486840

Excel gets hungup when Copy Paste
 

NOPE...no formulas....just massive worksheet.


*** Sent via Developersdex http://www.developersdex.com ***

Excel gets hungup when Copy Paste
 

what about using a database query to retrieve the data instead of
copy/paste

--
MattShoreso
-----------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347
View this thread: http://www.excelforum.com/showthread.php?threadid=48684