Finding cells in a range
Instead of Cells.Find use the specific range, such as Range("A1:H10").Find.
Cells is all cells in the worksheet.
--
HTH
-------
Bob Phillips
"Bob Leathers" wrote in message
...
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
|