(Solved) – Issue with inserting formula

  • by
(solved)-–-issue-with-inserting-formula

I canoot get the formula to work on my sheet. I’ve tried adding extra quotes and spacing between the “&”. Line D is a date value and I want to combine “=D2” and “C2” values. Any assistance would be appreciated.

Sub insertValue()
  Range("A1").Value = "id"    'integer
  Range("B1").Value = "money"    'integer
  Range("C1").Value = "Note"    'string
  Range("E2").Formula = =c2 &"" "" & TEXT(d2,"mm/dd/yyyy")    'error on this line

End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *