View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vladimir Sveda[_2_] Vladimir Sveda[_2_] is offline
external usenet poster
 
Posts: 1
Default convert text to number - performance problem

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