Thread
:
convert text to number - performance problem
View Single Post
#
2
Posted to microsoft.public.excel.programming
Jim Cone[_2_]
external usenet poster
Posts: 1,549
convert text to number - performance problem
Vlado,
What are you trying to accomplish?
Numeric values in cells are always type Double.
--
Jim Cone
Portland, Oregon USA
"Vladimir Sveda"
<Vladimir
wrote in message
In my VBA code I use:
....
For Each c In Range("MyRange").Cells
c.Value = CSng(c.Value)
Next c
....
and it is performance bootleneck of that code
Can you, please, suggest better code.
Thank you in advance!
Vlado
Reply With Quote
Jim Cone[_2_]
View Public Profile
Find all posts by Jim Cone[_2_]