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/