what's wrong with my IF statement?

[anis]

            Range("A5").Offset(1, 0).Select
            Do Until ActiveCell.Value = ""
            If ActiveCell.Text = "J750*" Or ActiveCell.Text = "=A5*M*" Then ActiveCell.EntireRow.Hidden = True
            ActiveCell.Offset(1, 0).Select
            Loop

the wildcard character is not working...y is that?

 

[CraigM]

Try using the Like operator instead ie:

ActiveCell.Text Like "J750*"

Have a look at the help file on the Like operater for more info.

 

[anis]

it works~!! thank you..i never knew that exists...THANX~!