Store Cells Value VBA

[tbrozovich]

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!

[daffodil11]

Please Login or Register  to view this content.

[tbrozovich]

Ah so simple! Thanks a bunch!