Excel: need to move to next cell down 1

[azzi2000]

Ineed to go to next cell down:

Application.Goto Reference:="R65000C1"
Selection.End(xlUp).Select
'need code to go next cell down 1 row

Please advice,
Thank you.
Dré

 

[SkipVought]

Hi,

ActiveCell.Offset(1,0).Select

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[SkipVought]

or...

Cells(Cells.Rows.Count, 1).End(xlUp).Offset(1, 0).Select

But I don't recomment doing a bunch of Activates and Selects in a macro...

How Can I Make My Code Run Faster? faq707-4105

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[azzi2000]

Thank you.
Dré