Need faster paste special values

[HerryMarkowitz]

Hi everyone,
I have an excel sheet which consist of 6000 x 500 cells with full of formulas.
In order to paste values without formulas I tried these two different ways.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The two codes above takes 12 minutes to complete.

Is there any other way to speed up this paste special values process ?
Best wishes.

[HerryMarkowitz]

By the way, I know these codes.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[AB33]

12 minutes is very long.

What is the value of column A? Why can not you use BA2 or HOT column?
Could you please attach the sample to see what could be the reason?

[HerryMarkowitz]

Hi AB33,
I can not attach a file because of it is very huge.
12 minutes is very long because my computer is 5 years old and has 3 GB Ram.
There are some other text values between A and AZ columns.
Cells with formulas start with BA column and end HOT column.
My file is about stock values, like open prices, high prices, low prices, close prices...

[AB33]

I mean this way. It may not make any difference.

Please Login or Register  to view this content.

Are these data exported from sites in to excel? If so, these would be the most likely reason for slowing the code.

[jindon]

See if this makes difference

Please Login or Register  to view this content.

[HerryMarkowitz]

None of your ideas better than mine...