ExcelBanter - Formula ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula ? (https://www.excelbanter.com/excel-programming/333852-formula.html)

Bob Phillips[_7_]

Formula ?

xlsRange.Formula = S

--
HTH

Bob Phillips

"Joe" wrote in message
...
Hi
I tried to put a formula (vb+vba) and could not do it.

Code:
S="=IF(ISBLANK($C1),,$C1-$D1)"
xlsRange.FormulaR1C1 = S

When I opened the file, the formula was:
=IF(ISBLANK($K:$K),,'D11'-$K:$K)

What is wrong?

Thank you.
Joe

Joe[_39_]

Formula ?

Hi
I tried to put a formula (vb+vba) and could not do it.

Code:
S="=IF(ISBLANK($C1),,$C1-$D1)"
xlsRange.FormulaR1C1 = S

When I opened the file, the formula was:
=IF(ISBLANK($K:$K),,'D11'-$K:$K)

What is wrong?

Thank you.
Joe

All times are GMT +1. The time now is 01:04 PM.