Space.

[Tom]

Hello,

I need know if variable contents space, for example:

myvar = "da tas"

if myvar (contens space) then ....


Thanks Tom

 

[Dave Hawley]

Hi Tom

myvar = "da tas"
If InStr(1, myvar , " ") Then
MsgBox "Space"
End If

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***