Range("P" & fila).formula = "=IF(H" & fila & "="""",IF(G" & fila & _
"="""","""",G" & fila & "-E" & fila & "),H" & fila & "-E" & fila & ")"

--
Regards,
Tom Ogilvy


"Santiago" wrote in message
...
I'm pretty new with programming in excel. I'd like to know why the
following
code does not insert the formula in the cell "P" & fila. Fila is a
variable
(number) that changes in a loop.


Range("P" & fila).Formula = "=IF(H" & fila & "="",IF(G" & fila &
"="","",G"
& fila & "-E" & fila & "),H" & fila & "-E" & fila & ")"

Thanks!

Bregards

Santiago