Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search parts of a spreadsheet
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!!!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search parts of a spreadsheet
Simply hide the rows and columns you don't want it to search into. This can be done by code. You the Unhide them. -- raypayette ------------------------------------------------------------------------ raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569 View this thread: http://www.excelforum.com/showthread...hreadid=563260 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy parts of a data range into a new spreadsheet | Excel Worksheet Functions | |||
Search Spreadsheet for a name | Excel Discussion (Misc queries) | |||
Search parts on a spreadsheet | Excel Programming | |||
Search Spreadsheet - Results in either listbox or new spreadsheet | Excel Programming | |||
How do I create shortcuts to take me to parts of a spreadsheet? | Excel Discussion (Misc queries) |