sumif cells

Hi all,

Instead of the value Cells(intRow, intCol + 80).Value i would like to see in Excel the cells which the sumif is refering to. Like:
sumif((Bron!$A:$A,CA60,Bron!$E:$E)

instead of:

objWs.Cells(intRow, intCol).Formula = "=SUMIF(Bron!$A:$A,""" & Cells(intRow, intCol + 80).Value & """,Bron!$E:$E)"

Would it work if you did this instead?

Please Login or Register  to view this content.

It works! Thx!