Posted on 2013-06-21
I have some code that does some stuff pretty well, but I am trying to get a cell to have the value of a couple of cells and a varible, this line of code....
WS4.Range("A2") = WS1.Range("C2") & " to " & Cust & " del " & WS1.Range("E2").Value
works fine in as much as it places the the three values I want into the correct cell but the date part, "(& WS1.Range("E2").Value)" is formatted as dd/mm/yyyy, and I want dd/mmm.
I have been trying for a while now, to no avail.
As always any help is much appreciated.