cell formula manipulation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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
 
Back
Top