Thread: Formula in a coloum
View Single Post
  #5  
Old March 7th, 2010, 07:08 PM posted to microsoft.public.excel.newusers
franco monte
external usenet poster
  
Posts: 10
Default Formula in a coloum
Dave, it seems work correct, is it right for you?

With Range("G3:G" & UltimaRiga)
.NumberFormat = "0_ ;[Red]-0 "
.Formula = "=D3-I3"
.Value = .Value
End With