Specific cell selection

pepsicube

New Member
Joined
Dec 5, 2005
Messages
12
Help

I need a macro to select a cell which will allways be 1 row below and 5 columns to the right of a cell containing a unique string {> (this cell will allways be in column T)

Thanks
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
ActiveCell.OffSet(1, 5).Select

or

Selection.OffSet(1, 5).Select
 

Watch MrExcel Video

Forum statistics

Threads
1,119,271
Messages
5,577,124
Members
412,769
Latest member
VK12345
Top