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.