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

"NickHK" skrev:

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

NickHK

"Arne Hegefors" wrote in message
...
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!