Need improve speed of transpose & delete row shiftUp (11 minutes)

I don't see this in your code, so I'm asking: did you try Application.ScreenUpdating property?
According to MS Excel VBA Help:

Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster.

I can not guarantee it will speed up your macro, but give it a try.

Hi Sbarro79,
Thank you for your response.
Yes, the code run 11 minutes including "Application.ScreenUpdating = False & Application.ScreenUpdating = True"

Regards,
tt3

Try step into macro and run through with F8 to see if there is a major hold up somewhere

Hi Phil,
There's no major hold up somewhere in the code. I think the code takes a certain amount of time to create one row and then multiply it by 500 to get the total time.

Regards,
tt3

Please Login or Register  to view this content.

Please help. Any alternative methods are fine.

Regards,
tt3

I just ran the macro with 500 rows in column B and it took less than a minute to run. Maybe it is an issue with your computer?

Hi Phil,
Thank you for your time. I have a sample in the attached and please test again.

Regards,
tt3

Ok.
That one took about 2 minutes to run

Hi Phil & Waswodge,
Thank you for your time and help. The issue is from the code ''''''''Delete Row Value = 0''''''''. I'm looking for alternative method such as filter to see if it can run better.

Regards,
tt3

Code below is for reference only and looking for a better code:

Please Login or Register  to view this content.

What isn't it doing that you want it to do?

Hi Phil,
I did re-test a sample & real workbook at work today and it took less than a minute on some desk/lap top. The speeding issue happened when the user open two or three wb even they just run one wb at a time but some how it took forever like 5-11 minutes. Another speeding issue is from my boss Macbook pro, runs on 7-11 minutes (OS win7, quad cores I7, 2.2GHz 8G RAM, 512 SS HD). I'm looking for alternative method of delete row shiftUp to see if it can help improve speed on Macbook Pro.

Regards,
tt3

Hi Jindon,
I did test with your code and it works more than I expected. I test three time and it took 2 minutes on Macbook Pro and 3 seconds on two desktops.

Thank you very much for your time and help (Jindon, WasWodge, Phil, SBarro).

Regards,
tt3