Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperately Seeking FirstCell Find !
I am trying to search in the fist column of a range using the following
code. The problem is that the first item is never searched as it allways starts 'AFTER' the top left hand cell, so I have a column of numbers 1 to 16 and I want to find 1, it starts at cell 2 and therfore never find the 1 Any Ideas ??? Public Function lookupRange(ByVal rangeName As Range, key As Variant, col As Presets) As Variant On Error Resume Next Dim mr As Range Set mr = rangeName.Find(what:=key, LookIn:=xlValues, lookat:=xlWhole, SearchDirection:=xlNext, SearchOrder:=xlByColumns) lookupRange = mr.Offset(0, col) End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Desperately seeking ACTIVE.WORKBOOK function for XLM | Excel Worksheet Functions | |||
DESPERATELY NEED HELP | Excel Discussion (Misc queries) | |||
Desperately Seeking Offset Formula!! | Excel Discussion (Misc queries) | |||
Desperately need help!! | New Users to Excel | |||
Desperately seeking some help! (Please) | Excel Programming |