Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DownArrow?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DownArrow?
CLR,
Application.Goto Reference:="R8C1" Selection.End(xlDown).Offset(1,0).Select John "CLR" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DownArrow?
Selection.End(xlDown).Select
would become: Selection.End(xlDown).offset(1,0).Select CLR wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
DownArrow?
CLR wrote:
*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 * With out testing I would say after all that put selection.offset(1,0).select Keith www.kjtfs.co -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
DownArrow?
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 "John Wilson" wrote in message ... CLR, Application.Goto Reference:="R8C1" Selection.End(xlDown).Offset(1,0).Select John "CLR" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shift-Ctrl-DownArrow | Excel Discussion (Misc queries) |