View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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