Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel hangs when copy 'n' pasting
Hi,
I want to record the process of copying a row in a tabular region in my main worksheet and pasting the format of the row into the next line. However, after doing this, excel hangs/stalls/freezes. The only way to get out of this is to click the close "X" on the application window but then select "Cancel" on the confirmation box, which will return you to the document in a normal state. I don't understand why this is occuring?! FYI - I have a file of size 460Kb and around 30 worksheets. In the "This Workbook" module, I have a change event handler to pick up any changes in any of the worksheets but I need this as it is a vital part of the functionality of the tool I'm building - which is to basically pick up changes made in the individual worksheets and summarise them in the main sheet. Any suggestions and help would be greatly appreciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste from Excel to powerpoint the pix is Truncated | Excel Discussion (Misc queries) | |||
How to remove an extra line added by excel when pasting into notep | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
pasting excel data in a powerpoint slide | Excel Discussion (Misc queries) | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) |