Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
union/disunion?
I have a macro that searches a spreadsheet for certain cells that contains
certain values. In some cases I need to specify that I olny want to search parts of the spreadsheet. For example I first search for the word "IMM" and then I search for the word "FUTURE". I then want to search to rest of the spreadsheet for the word "DATE" i.e. search all rows except for the rows that conatins IMM and FUTURE. I know that there is a union thing in Excel but is there a thing such as disunion? My code looks like: Dim searchRange As Range Set searchRange = Range(Cells(secID.Row, 1), Cells(secID.Row, 100)) Set secID = Worksheets("Sheet").Range(Cells(segment.Offset(i, j).Row, 1), Cells(3000, 100)).Find("Date", LookIn:=xlValues) I need to handle this varibly because it changes all the time. Please help me out if you can! Thank you very much!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
union problem | Excel Programming | |||
Help w/ Union Queries | Excel Discussion (Misc queries) | |||
Union question | Excel Programming | |||
Union only works for sometimes. | Excel Programming | |||
VBA union of two ranges | Excel Programming |