Macro stops responding...

[wayliff]

I have a macro that does some routines for me. I have not used it for about 6 months in the past it would take some time (very slow) to run through this part of the code but now it simply does not seem to continue. I can let it run for 20 mins and does nothing...i am hoping for some insight on how to resolve this issue.

Sheets("spreadsheet.xls").Select
lastrowm = Sheets("tab").Range("A6").End(xlDown).Row
Range("A5:X" & lastrowm).Select
Selection.Copy
Windows("spreadsheet2.xls").Activate
Sheets("tab").Select
Range("A5").Select
ActiveSheet.Paste

When the macro executes PASTE it just sits there. Not sure why.

In the meantime I have been placing a break point on Range("A5").Select and I manually paste the stuff and then i continue...

This makes no sense to me.

Help appreciated

[rylo]

Hi

Sounds like you either have some heavy processing formulas, or links to closed files in the data you are copying. Or perhaps there are links in the copy area that point to other sheets in the source file, and it is taking a while to process when they are copied across.

Can you provide more detail on the type of data in the range being copied?

[wayliff]

I have tested it with a single row of data or many (1200) and it takes the same amount of time. (Once done manually it is almost instantaneous)
There aren't any formulas at the moment it is being copied since everything has been pasted as a value and there are not references to other sheets or workbooks.

The type of data is alphanumeric...

From Columns A to O.

Col A - Three Letters
Col B - Five Digit Number
Col C - Nine Digit Number
Col D - Two Digit Alpha Value
Col E - Julian Date
Col F - Three to Four Digit Number
Col G - Alphanumeric field, varies in size but never exceeds 10 characters
Col H - Same as Col F
Col I - Date
Col J - Text of about 3 to 10 characters
Col K - Blank or the word Freeze
Col L - Text from 3 to 10 characters
Col M - Text from blank to 255 characters. Generally not many.
Col N - Same as M.
Col O - Same as M.

[rylo]

Couple of other thoughts.

1) How many other files do you have open, and do they have much activity.
2) Does turning off the calculation speed things up.
3) Are there any event macros that are being fired by the copy / paste.


rylo