DownArrow?

  • Thread starter Thread starter CLR
  • Start date Start date
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
 
CLR,

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

John
 
Selection.End(xlDown).Select
would become:
Selection.End(xlDown).offset(1,0).Select
 
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
 
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
 
Back
Top