[RESOLVED] SumIf formula!!

Still having problem with formula

here it is:

VB Code:

ActiveCell.Offset(0, 3).Formula = "= SumIf(C12:" & [SunAdd] & ", >0, D12:" & [SunLyAdd] & ")"

what's wrong with it??
I'm having a Run time error 1004
applicatiion-defined or object-defined error

Thnaks

Do you have valid ranges? C12: & [SunAdd] and D12: & [SunLyAdd]

yes
just before this line I putted those lines and it works fine.

VB Code:

ActiveCell.Offset(0, 2).Formula = "=Sum(C12:" & [SunAdd] & ")"

VB Code:

ActiveCell.Offset(1, 2).Formula = "=Sum(D12:" & [SunLyAdd] & ")"

What does the following display?

MsgBox "= SumIf(C12:" & [SunAdd] & ", >0, D12:" & [SunLyAdd] & ")"

= SumIf(C12:$C$27, >0, D12:$D$27)

are we going foward with this answer?

Your criteria is invalid. >0 should be enlosed in double quotes.

VB Code:

ActiveCell.Offset(0, 3).Formula = "= SumIf(C12:" & [SunAdd] & ", "">0"", D12:" & [SunLyAdd] & ")"

Hey mickeyc1204 you rule

thanks again buddy, it makes my day...

:)