Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Method ; search area
Hi Group, Have below code. ActiveSheet is WorkSheets(1). Is this the correct syntax for the "search area"? Seems not to work. Thanks for any hints. Brgds CG Rosén Dim d With Worksheets(4).Range("B1:B100") '???????? Set d = .Find(ComboBox1.Text, LookIn:=xlValues) If d Is Nothing Then MsgBox "OK" Else MsgBox "NIL" End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT search versus other method | Excel Discussion (Misc queries) | |||
Method of selecting an area with a macro | Excel Worksheet Functions | |||
The find method | Excel Programming | |||
Help with the Find method | Excel Programming | |||
The Find Method | Excel Programming |