The basic structure here would be :-
'----------------------------------------------
If .......... Then
'code
ElseIf ............ Then
'code
ElseIf ........... Then
'code
Else
'code
End If
'-----------------------------------------
You could presumably do a similar search for ":" to get time, or you
might find this useful :-
If IsNumber(c.Value) Then c.Value = "number"
---
Message posted from
http://www.ExcelForum.com/