VBA - Refrence cells and keep format

[30136353]

HI Guys,

I have the below piece of code that references 2 cells, which contains dates but formatted as address numbers. I.E Shows within the cell as "7/1", but actual value is 07/01/2020 or 43837. I need the code to reference the "7/1" format as I then later in the code use this reference to search for the address online... Can anyone assist?

    Range("O2:O" & Range("A" & Rows.count).End(xlUp).Row).Formula = "=B2&c2"

 

[Fluff]

How about

Range("O2:O" & Range("A" & Rows.count).End(xlUp).Row).Formula = "=text(B2,"d/m")&text(c2,"d/m")"

 

[30136353]

How about

Range("O2:O" & Range("A" & Rows.count).End(xlUp).Row).Formula = "=text(B2,"d/m")&text(c2,"d/m")"

Hi, thanks for the reply. That line just gives me a syntax error straight away?

 

[Fluff]

Oops, it should be

Range("O2:O" & Range("A" & Rows.count).End(xlUp).Row).Formula = "=text(B2,""d/m"")&text(c2,""d/m"")"