Convert small macro smaller+efficient, receiving message (On and Off) No Responding

Good Morning,

I have over 20 code that i called on Macro over Macro and all of them are working Fine except with one.I done this Macro over a year ago

It use to run on less than 2 minutes, some how i delete or remove some code line and i did
the Macro again but this time It takes too long (over 5 minutes) and i'm receiving a message
On and Off (Top left on screen) (No Responding) but at the end it does the job

Basically these are the Step what this Macro does:
Select sheet1,
A-.On row 37(with data) -> Insert sheets Row
B-.Drag UP data from Cell C38 to new (empty) Cell C37
C-.Cell D37 no action (leave empty)
D-.Drag UP data from rows E38:IE38 to new (empty) rows E37:IE37

For Sheet 2
Select sheet2
A-.On row 37(with data) -> Insert sheets Row
B-.Drag UP data from rows C38:IE38 to new (empty) rows C37:IE37

For Sheet 3 (exact same action as Sheet2)
Select sheet3
A-.On row 37(with data) -> Insert sheets Row
B-.Drag UP data from rows C38:IE38 to new (empty) rows C37:IE37

Note :
This time I did a Macro only for Sheet1, if a member help me with at least one i try to figure it
how to do the other one. Or if i typed i mistake please let me know..

Thanks and in advance i appreciate :

Please Login or Register  to view this content.

.
It runs without issue here :

time.jpg

Hi Logit,

If macro is tested draggin empty rows it takes 00:00 time but when dragging data it take a almost 5 minutes.
The 5 minutes waiting is not a problem.
The Issue is that when is running the Macro for 3 sheets i got on top left corner of the excel screen the Message (No Responding) it display On and Off.
Im dragging no more than 4 kind of differents formulas in the the Range (its about 230 formulas in total.
This are the formulas :

Please Login or Register  to view this content.

I google it the no responding tinghi and i found that i have to eliminate any add-in
Which I did but the samething s happening

When I test the others 19 Macros (with out this macro)the worksheet Is really fast (1:30 minutes) and i have no message.

I record The Macro stepping different way and it get worst (keeping longer time the No responding message)

BTW This is the entire Macro for the 3 sheets:

Please Login or Register  to view this content.

Thank you!

Hi Winon,

Thanks for your response.
Yes i tough about it, but workbook have 11 worksheets and some data is dependable between WS,
and i don't know which one are
I see what is the best way to do it..


Thanks!

Hi Winon,

It take the same time and still have On and Off the Message No Responding.

I think its taking long because It not respond to a some (or few) calculations, That's i'm going to find out.

Also I'll going to find out which are the Add-in that comes standard on excel 2010 and i'll run the repair option.


Thank you so much, appreciated a lot!


AndyJr