Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i have a code like this
Columns("A:A").Select ' Find Other Bank and Cash On Error Resume Next Selection.Find(What:="89001/43", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Select If ActiveCell < 89001/43 Then Range("A1").Select Do While Selection < 89000 Or Selection 89176 Selection.Offset(1, 0).Select Loop End If my problem is that the slash is alway converted to division. Can somebody pls help me. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check number within a range | Excel Worksheet Functions | |||
loop through cells in a range and pick up corresponding cell values in another range | Excel Programming | |||
How do I check repeating sets of number in a range | Excel Worksheet Functions | |||
Check if a number exists in a range? | Excel Discussion (Misc queries) | |||
Create a Loop to check cells between workbooks | Excel Programming |