Re: Can we use "*" to replace string in VBA excel macros ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tomek (tomolder28_at_gazeta.pl)
Date: 02/12/05 

Date: Sat, 12 Feb 2005 16:58:45 +0100

Tom Ogilvy wrote:

> The example I gave would produce where the string is found. As long as it
> isn't zero, you would copy. I am not sure why you can't make it. The
> example needs no interpretation - When the condition is passed, you copy.
>
>
I tried something like below but I do not know why it dosn't work
 
Sub proba2()
If InStr(1, "A1", "B1", vbTextCompare) > 0 Then
ActiveCell.Offset(10, 0).Activate
End If
End Sub

in cell A1 I had string "very big car"
in cell B1 I had string "big" 

-- 
Tomek