Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want a macro to find a value in a range and select the cell that matches
the find criteria, after the cell is selected I need it to offset down 20 rows. Range("M3:IV3").Select Selection.Find(What:="Rad", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ********Select Found Cell************ ********Offset (Down) 20 Rows************** Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find String in Cell then Paste Sum in Offset Cell | Excel Programming | |||
Find word then use offset to change value in another cell | Excel Programming | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
vba help pls - find min based on a condition and return val of an offset cell | Excel Programming |