►VBA◄ reference cells.

[montecarlo2012]

Hi,
According to the reference cells theory:

Using Range Method: Range (“C5”)
Using Cells Method: Cells (5, 3)

Supposedly are equal so

why this macro work

Sub Macro2()
   Range("C5").Formula = "=IF(C1<D1,TRUE,FALSE)"
End Sub

and this one Don't

Sub MACRO3()
 Cells(5, 3).Formula = "=IF(C1<D1,TRUE,FALSE)"
End Sub

Thanks.

 

[Ezguy4u]

montecarlo Can you elaborate on what isn't working. I used your program and both macros work for me.​

 

[montecarlo2012]

Thank you Ezguy4u, was my mistake, I didn't used the spaces correctly. sorry false alarm.