View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
franco monte franco monte is offline
external usenet poster
 
Posts: 10
Default Formula in a coloum

I have this code

UltimaRiga = Range("A65356").End(xlUp).Row
For i = 3 To UltimaRiga
Range("G" & i).Value = (Range("D" & i).Value - Range("I" &
i).Value)
Range("G" & i).NumberFormat = "0_ ;[Red]-0 "
Next i

but I think is better (faster) without loop, is it possible?
Thanks in advance!