Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to find cells only within a specific range such as b8:I164
The following works fine except it acts upon the whole spreadsheet and changes cells (with my code) that I do not want changed Cells.Find(What:=Range(myFind), After:=ActiveCell, LookIn:xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False).Activate How do I limit the range that is searched? Thanks Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding the earliest date from a range of cells | Excel Worksheet Functions | |||
Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
Finding unnamed cells in a range | Excel Discussion (Misc queries) | |||
Finding the last value in a range of cells | Excel Discussion (Misc queries) | |||
finding a range of cells to match a date | Excel Programming |