Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intersect Method
I am trying to use interset method to locate a cell and get the value from
that cell. My cod now is: Dim cell1 As Range Dim cell2 As Range cell1 = segment.Offset(0, m).Address cell2 = segment.Offset(i, 0).Address Set isect = Application.Intersect(Range("cell1"), Range("cell2")) and it does not work at all. I have to use the segment.Offset() somehow because I use that code to find other cells like this: Do Until segment.Offset(i, 0).Value = "Cash" Or i 5000 i = i + 1 Loop Please help me with this code! Thanks very much in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Intersect | Excel Programming | |||
Intersect | Excel Programming | |||
Method 'Intersect' of object '_Global' failed | Excel Programming | |||
Exception when uisng Intersect method | Excel Programming | |||
Is there a "Non-Intersect" VBA method to remove a sub-range from a range? | Excel Programming |