Finding cells in a range

[Bob Leathers]

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

 

[Guest]

Bob-

The first part of your code is defining the range you want to look in. The
"Cells" method without qualifiers returns all of the cells in the worksheet,
so "Cells.Find" means you are looking in all of the cells.

To limit the range you look at use something like
Range("B8:I164").Find(What=...

Stan Shoemaker
Palo Alto, CA

 

[Bob Phillips]

Instead of Cells.Find use the specific range, such as Range("A1:H10").Find.
Cells is all cells in the worksheet.

 

[Bob Leathers]

Thanks for the help Folks. But this did not work.

I got the error message

Run-time error '1004':
Unable to get the Find property of the range class

with coding as follows Range("B8:I164").Find(What:=Range(myfind),.....

I did not mention that I am using Excel 97 SR2, could this be a feature
not available in 97?

Any other suggestions?

Thanks

Bob