View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CM4@FL[_2_] CM4@FL[_2_] is offline
external usenet poster
 
Posts: 12
Default VBA: Select Cell using find function and offset

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