Can anyone tell me why this code does not have quotes around it when I copy and paste AF12.Value to word.
and this one does?
The only difference is the vbTab..
Code:
Range("AF12").Value = " Price: " & Format(Cells(.Row, 15).Value, "$##,##0.00##") & " each"
Code:
Range("AF12").Value = " Price: " & vbTab & Format(Cells(.Row, 15).Value, "$##,##0.00##") & " each"