convert text to number - performance problem
Thanks to all, solved by "philosophy change" (and of course algorithm change)
Vlado
"Vladimir Sveda" wrote:
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
|