Search parts of a spreadsheet

A

Arne Hegefors

I try to search part of a spreadsheet for a certain word. The code is:

Set rng1 = Worksheets("Beräkning").Cells.Find("Segment", LookIn:=xlValues)


Set rng5 = Worksheets("Beräkning").Range(Cells(rng1.Row, 1), Cells(3000,
100)).Find("Security ID", LookIn:=xlValues)

the first search works fine but the second does not. It is the Range(.. the
gives me problem it works without. However I have skipped some parts of the
code and it is necessary that I search only a certain area. How are you
supposed to write this? I really would appreciate help!!!!!!
 
R

raypayette

Simply hide the rows and columns you don't want it to search into. This
can be done by code. You the Unhide them.
 

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