DownArrow?

C

CLR

Hi All...........

This code gets me to the last cell in Column A that contains data, but then
I want to go down one more row.........how to do that please?

Application.Goto Reference:="R8C1"
Selection.End(xlDown).Select

TIA
Vaya con Dios,
Chuck, CABGx3
 
J

John Wilson

CLR,

Application.Goto Reference:="R8C1"
Selection.End(xlDown).Offset(1,0).Select

John
 
D

Dave Peterson

Selection.End(xlDown).Select
would become:
Selection.End(xlDown).offset(1,0).Select
 
K

KJTFS

CLR said:
*Hi All...........

This code gets me to the last cell in Column A that contains data
but then
I want to go down one more row.........how to do that please?

Application.Goto Reference:="R8C1"
Selection.End(xlDown).Select

TIA
Vaya con Dios,
Chuck, CABGx3 *
Click to expand...

With out testing I would say after all that put
selection.offset(1,0).select

Keith
www.kjtfs.co
 
C

CLR

Thanks John,
You're the First Responder, and your suggestion works "finer than frog
hair"...........

And thanks to the other responders too.......you guys are all the
greatest...........

Vaya con Dios,
Chuck, CABGx3
 
Top