Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells.find restricted to a single range??
I have the below code to search for a number in my sheet.
However, I only want to search the range "rngtest", and if the numbe does not exist in that range, it should return only a msgbox saying n such entry. What should be changed??? Dim iSpecific As integer Cells.Find(What:=iSpecific, After:=Range("A1"), LookIn:=xlFormulas LookAt _ :=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext MatchCase _ :=False, SearchFormat:=False).Activate Cheers Stef -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restricted Cells | Excel Worksheet Functions | |||
Restricted Range in Auto filter | Excel Discussion (Misc queries) | |||
Password restricted single macro and button | Excel Discussion (Misc queries) | |||
Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
Protecting single cells or a range | Excel Discussion (Misc queries) |