Excel VBA Plus Symbol Automatically Getting Added

[ranjith2523]

Hi Friends,

I wrote a simple single-line coding to bring the C2 value to D2 in Excel VBA.

ThisWorkbook.Sheets("MM_Input").Range("D2:D2") = "=C2"

After I executed the above code I noticed a weird result in cell D2 like the one below, I do not understand why the plus symbol automatically gets added once I execute the VBA code and repeat the formula twice in cell D2.

Do I need to change any settings in my Excel? Till last month there were no such issues found in my system.

Please help me on this.

Regards,
Ranjith

 

[Fluff]

Try it like

ThisWorkbook.Sheets("MM_Input").Range("D2").Formula2 = "=C2"

 

[ranjith2523]

Try it like

ThisWorkbook.Sheets("MM_Input").Range("D2").Formula2 = "=C2"

Thank you .. It works as expected

 

[Fluff]

You're welcome & thanks for the feedback.