Change text to values and adjust column location

Hopefully you can help me get this figured out!!

Please Login or Register  to view this content.

I am using the same code as above, but changed the columns. If I use the columns above, no issues. If I use the new columns (same data in the columns) Excel freezes up. Error: Excel cannot complete the task with available resources. Keep in mind, that if I run the same code on the same data, there are no issues. I only changed the column from ("GW:GW, JC:JE") to ("D:F"). Been at it for 3 hours, changing things around ect. to no avail!!!!

My Code:

Please Login or Register  to view this content.

Try this instead:

Please Login or Register  to view this content.

No good. It freezes Excel. This is really bizarre. The old code worked perfect and still does using the old cell values...but now that I changed the cell values, it does not.

If it helps, the entire code is below. I would appreciate any help.

Please Login or Register  to view this content.

Here is something interesting. If I use the original code with the original cells, it works fine, no issues. But the only change was the range.

Please Login or Register  to view this content.

Please post code within

Please Login or Register  to view this content.

[/NOPARSE] tags. You can still edit your previous posts to add them in.

If it is freezing with the code I suggested, most likely because you have too much data and formulas/conditional formatting/etc.

Thing is, it's not changing any "format", but to General type, so numbers will be treated as numbers, text as text.

Try copying your data to a new empty workbook and try the code.

A couple of questions, are you using FORMULAS in those columns instead of flat values? The xlConstants reference won't see cells with formulas.

In my original version I used cDbl() which attempts to extract the numeric values from the text. You can also try replacing the with Val().

You'd have to post a workbook with the macro that is misbehaving. It's all just guessing without it.

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.