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