How to pass cell Value as String in VBA Formula - Avoid them to become as range

Hi All,

I have one code column, Codes are like A03-01, A03-02 and so on. When i pass this in Sumifs Formula in VBA, A03-01 code becomes A3-1 and A3 is treated as range.

Please help me to understand, how can i pass A03-01 as string in the VBA Formulas.

Should be This: "=SUMIFS(Sum_Range,Criteria_Range,A03-01)"

But Become: "=SUMIFS(Sum_Range,Criteria_Range,A3-1)"

now A3 becomes Cell Adddress.

Thanks in Advance!