Thank you both. I will need to make it so that the script does not sto
when it hits a blank in the road.

So I just press alt-F11 to enter the VBA edit mode right?

Thanks again,

Jerem

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

I don't see your e-mail address Rob. Mind e-mailing me first? Mayb
you could let me know how to make that work with text?
Thanks again! - Piku

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

This is not working for me. I get errors in VBA. Using the format cells
option will not work for me. Eventually thesee numbers will be
converted to a date using another formula.

Any ideas?


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