if statements.
 

1MLIBGB.

CAN I USE AN IF STATEMENT FOR THE ABOVE WORD THAT TAKES INTO ACCOUNT THE 1
AND THE M

IE THE 1 AND M CHANGES CAN I CAPTURE THIS USING AN IF STATEMENT?--
chesty

if statements.
 

Typing in all CAPS is considered bad netiqutte. SHOUTING!
try this idea
=IF(ISERR(FIND("M",A14)),1,2)

--
Don Guillett
SalesAid Software

"chesty" wrote in message
...
1MLIBGB.

CAN I USE AN IF STATEMENT FOR THE ABOVE WORD THAT TAKES INTO ACCOUNT THE 1
AND THE M

IE THE 1 AND M CHANGES CAN I CAPTURE THIS USING AN IF STATEMENT?--
chesty

if statements.
 

Try this, let us know how you get on

Sub IfChange()

Dim LastRow
LastRow = Sheet1.UsedRange.Row - 1 _
+ Sheet1.UsedRange.Rows.Count

For x = 1 To LastRow

If Mid(Sheet1.Range("A" & x).Value, 1, 2) < "IM" Then
MsgBox "Its Change! " & Mid(Sheet1.Range("A" & x).Value, 1, 2)
End If
Next x

End Sub



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200605/1