Search parts on a spreadsheet

[Arne Hegefors]

Is there any way to search parts of a spreadsheet? As it is now I search a
spreadsheet for certain words like this:

Set rng5 = Worksheets("Beräkning").Cells.Find("Market value RC",
LookIn:=xlValues)

Is it possible to search etc. only the five first rows, the third column
etc? I have to do this variably so I cannot record a macro for this. Please
help me! Thanks!

 

[NickHK]

Arne,
You can specify any range to search:
Set rng5 = Worksheets("Beräkning").Range("A3:89").Find(...etc

NickHK

 

[Arne Hegefors]

Great thanks! What I really want to do is to search the spreadsheet except
for certain ranges. Is this possible? Thank you!!!!

"NickHK" skrev:

 

[NickHK]

Arne,
AFAIK, there nothing that is the opposite of UNION, so I guess you would
have build your range from the ranges that you do want. e.g.
Dim SearchRange as Range
Set SearchRange = UNION(Range("1:5"),Range("C:C"),,,etc
Set rng5 = Worksheets("Beräkning").SearchRange.Find(...etc

NickHK