If Instr(yourstring, whatyouwanttosearch) 0 Then

'code in case found

Else

'code in case not found

End if



--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Rivers" wrote:

is there a way to search a variable containing "mydoc.doc" for the "." and if
found do the next line i tried

if sel=*.* then

but it doesnt work any ideas

thanks

Rivers