Concatenate Double Quotaion in VBA

[rizmomin]

Hello:

I have A1 = 10/17/2019
A2 = Text as WH
A3 = Text as WO

I need VB Code to add Formula in cell A4 to give me 10-17-2019-WHWO

I tried as below

Range("A4").Formula = "=TEXT(A1,""MM-DD-YYYY"" & ""-"" & ""A2""&""A3"")"

Please let me know if you have any questions.
Thanks.

Riz

[Pete_UK]

Your closed bracket should be after the YYYY"" part, and if you had YYYY-"") you wouldn't need the & ""-"" part. I'm not sure why you have any quotes around the A2 and A3.

Hope this helps.

Pete

[rizmomin]

Hello Pete:

I got it, Thanks a lot

Riz

[Pete_UK]

Oh, hello Riz - I didn't notice that it was you that I was replying to.

Glad to help, and thanks for the rep.

Pete