Search parts on a spreadsheet

A

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!
 
N

NickHK

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

NickHK
 
A

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:
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top