How do I select a cell 5 cells from the active cell?

's Computer Specifications

seems simple enough, but i can't figure it out.

i am at a particular random location, and I need to select the cell 5
rows over.

TIA

JasonK

's Computer Specifications

One way:

Public Sub SelectCell5RowsFromActiveCell()
With ActiveCell
If .Row <= Rows.Count - 5 Then _
.Offset(5, 0).Select
End With
End Sub

In article <(E-Mail Removed)>,
JasonK <(E-Mail Removed)> wrote:

> seems simple enough, but i can't figure it out.
>
> i am at a particular random location, and I need to select the cell 5
> rows over.
>
> TIA
>
> JasonK

's Computer Specifications

five rows over

offset(,5)

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> One way:
>
> Public Sub SelectCell5RowsFromActiveCell()
> With ActiveCell
> If .Row <= Rows.Count - 5 Then _
> .Offset(5, 0).Select
> End With
> End Sub
>
>
> In article <(E-Mail Removed)>,
> JasonK <(E-Mail Removed)> wrote:
>
>> seems simple enough, but i can't figure it out.
>>
>> i am at a particular random location, and I need to select the cell 5
>> rows over.
>>
>> TIA
>>
>> JasonK

's Computer Specifications

OP may? have meant five COLUMNS over?

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> One way:
>
> Public Sub SelectCell5RowsFromActiveCell()
> With ActiveCell
> If .Row <= Rows.Count - 5 Then _
> .Offset(5, 0).Select
> End With
> End Sub
>
>
> In article <(E-Mail Removed)>,
> JasonK <(E-Mail Removed)> wrote:
>
>> seems simple enough, but i can't figure it out.
>>
>> i am at a particular random location, and I need to select the cell 5
>> rows over.
>>
>> TIA
>>
>> JasonK

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select specific cells in same row as active cell	michaelberrier	Microsoft Excel Programming	4	25th Jan 2007 09:04 PM
Select specific cells in same row as active cell	michaelberrier	Microsoft Excel Programming	1	25th Jan 2007 08:26 PM
find text in a cell and make cell 2 cells below that active	=?Utf-8?B?c2hhcmsxMDI=?=	Microsoft Excel Programming	4	20th Oct 2005 03:41 PM
active cell's movement from up/down/left/right adjacent to other select cells	Dan	Microsoft Excel Worksheet Functions	1	9th Aug 2004 04:47 AM
Select First Active Cell if the cell is in a pivot table	Don	Microsoft Excel Programming	0	30th Jun 2004 02:53 PM