A G
asked on
Excel VBA - Worksheet Function Syntax in VBA
Sheets(a.Name).Range("T2") .Offset(is + 2, 0).Value = "=Sumif(T" & 2 & ":" & "T" & is + 1 & "," & " '<0'" & ",D" & 2 & ":" & "D" & is + 1 & ")"
I get the application error on excel when I try to write the worksheet function in vba. The highlighted place is the <0 part which should be like "<" .
Thanks
I get the application error on excel when I try to write the worksheet function in vba. The highlighted place is the <0 part which should be like "<" .
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.