cell formula manipulation

[Guest]

hi all!

i have a cell with a formula in it
ie cell C1
=sumif(a1:a10,"B",B1:B10)

this formula is written with vba code

how can i reference this cell using
cells(rowNum,colNum) - and update it to be

=sumif(a1:a10,"B",B1:B10)+1

i want to be able to do something similar to
cells(rowNum,colNum)=cells(rowNum,colNum)+1
but with the resulting formula above

(hope this makes sense!)

J

 

[Trevor Shuttleworth]

J

one way:

Range("C1").Formula = Range("C1").Formula & "+1"

Regards

Trevor

 

[Bob Phillips]

Perhaps,

rowStart = 1
rowEnd = 10
colStart = 1
colEnd = 2

Range("C1").FormulaR1C1 = "=SUMIF(R" & rowStart & "C" & colStart & _
":R" & rowEnd & "C" & colStart & _
",""B"",R" & rowStart & "C" & colEnd & _
":R" & rowEnd & "C" & colEnd & ")"

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks to both!

Trevor's was the way i was looking for!

In reality my formula is much much more complicated than the one i used.

J