Michael,
The lines
With Range("C5")
.NumberFormat = "mm/dd/yy"
.Value = mydate
End With
actually enter the data. What do you mean re-enter the data? Do you want to
loop through different cells, or different values?
:also confused:
Bernie
MS Excel MVP
"daniels012 " wrote in message
...
Thank you so much for the info. As I said I am new to code in excel!
How do I get it to return to the cell to re-enter the data?
Michael
---
Message posted from http://www.ExcelForum.com/