Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Method question
Good Morning Group,
Have following problem with the Find Method in the code below. If the ActiveSheet Range contains values like 1 and 11 (or 2 and 22 etc) the code below does not find the value 1 but always the value 11. The search range is formatted as "general". Thankful for any hints. Brgds CG Rosén -------------------------------------------------------------------------- For I = 1 to 6 With ActiveSheet.Range("A" & I & ":" & "X" & I) Set k = .Find(TextBox1, LookIn:=xlValues) If k Is Nothing Then k = 0 End If End With Next I |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find method? | Excel Programming | |||
Find method example | Excel Programming | |||
The find method | Excel Programming | |||
The Find Method | Excel Programming | |||
The Find Method | Excel Programming |