input "sum()" in excel through VB

[Bullsandbears123]

I have the controls set to input my formula into an excel spreadsheet, but my formula does not format correct once set.
I am using this code where brow=beginning row and erow=ending row....
brow=1
erow=5

ActiveCell.FormulaR1C1 = "=SUM(S" & brow & ":" & "S" & erow & &quot"

I end up getting "=Sum('S1':'S5')" instead of..
"=sum(S1:S5)"

any ideas?

 

[dyarwood]

Try

Dim brow As Integer
Dim erow As Integer

in your code.

This should help

dyarwood

 

[Bullsandbears123]

yes, there is alot more code, but this is the problem area.

 

[dyarwood]

Maybe try setting the string as follows

cal = "=SUM(S" & brow & ":S" & erow & &quot"

Then

ActiveCell.FormulaR1C1 = cal

That might get round the problem

dyarwood

 

[Bullsandbears123]

Nope, makes no difference, there is something wrong in the way I'm doing it. I think I may need to use cell(S,brow) or some thing
Please any ideas are appreciated.

Thanks

 

[rdodge]

Instead of using the FormulaR1C1 property, try using the Formula Property like:

ActiveCell.Formula = "=SUM(S" & brow & ":S" & erow & &quot"

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.

 

[Bullsandbears123]

Works great THANKS