Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have declared a range in a prior statement, selected that range, and now
want to find a value within that range. For some reason, the program is looking outside of that range. What am I doing wrong? With ActiveCell Set range1 = Range(ActiveCell, .Offset(100, 0)) End With Range(range1.Address).Select Cells.Find(What:=Location, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find the last cell in a selected range? | Excel Programming | |||
Find last row and column in a selected range | Excel Programming | |||
Macro to find empty cell and select range to print selected. | Excel Programming | |||
Find Findnext in selected range | Excel Programming | |||
how to find last row/col index within a selected range | Excel Programming |