| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel gets hungup when Copy Paste
NOPE...no formulas....just massive worksheet. *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| Excel copy and paste | Excel Worksheet Functions | |||
| Copy and Paste in Excel | Excel Discussion (Misc queries) | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
Linear Mode
