| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statements | Excel Discussion (Misc queries) | |||
| If, Then Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| If statements | Excel Discussion (Misc queries) | |||
| operator statements, shorting when reusing one of the statements? | Excel Programming | |||
Linear Mode
