Hi,
I am trying to store a cell's value.
Dim sheet As String
sheet = Cells(4, answer).Value
The value of this cell is a date 6/29/2015 for example.
However, the formatting on this cell reads 6-29-15.
The script is copying the 6/29/15, Is there a way to store the 6-29-15.
Thanks!
Bookmarks