Help with EXCEL Formula via VBA

[neemi]

Please help....


I am trying to insert an Excel formula to a table via vba coding as follows:

Range(15, r.Row).FormulaR1C1 = "=IF(N" & r.Row & "-O" & r.Row & "<=0,0,N" & r.Row & "-O" & r.Row & ")"

but the cells just display the formula as text!!!

Does anyone know what could be causing this?

What am I doing wrong?

Cheers,
Neemi

 

[neemi]

sorry the code I am actually using is

Range(15, r.Row).Formula = "=IF(N" & r.Row & "-O" & r.Row & "<=0,0,N" & r.Row & "-O" & r.Row & ")"

Please help

 

[PHV]

Range(15, r.Row).Formula = "=...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[neemi]

Hi PHV...

Thanks for the quick response....

But i am actually using

Range(15, r.Row).Formula = "=...

and it only displays the formula as text!!!

 

[SkipVought]

Change the format of the cell from TEXT to GENERAL.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Bong]

Do you, by any chance, have the View option set to "formulas"? (in Excel 2007 that's in the Excel Options>Advanced menue under the curlycue symbol)

_________________
Bob Rashkin

 

[neemi]

I feel dum now!!!
All sorted!!!

Thanks PHV