SoccerStar,

Send me a message privately and I will send you a working example workbook.

HTH,
Bernie
MS Excel MVP


"soccerstr1 " wrote in message
...
ok, i tried running the macro and it didn't do anything. should this
line have the periods in the beginning?

.Value = TimeValue(TimeStr)

i tried leaving them in, but i got an error message. i then removed the
periods and the macro was selected. i then creasted the cells i needed
to edit, and then ran the macro and nothing happened to the selected
cells after i ran the macro


---
Message posted from http://www.ExcelForum.com/