View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Vladimir Sveda[_3_] Vladimir Sveda[_3_] is offline
external usenet poster
 
Posts: 1
Default 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