Try Some Like this

Sub MovetoEndDown()
Range("A1").End(xlDown).Activate '(xlToRight) in case you want to move to
the right.
End Sub
or
Sub MoveDownPlus1Row()
Dim NextRow As Variant
NextRow = Range("A20000").End(xlUp).Row + 1
Cells(NextRow, 1).Activate
End Sub

Hope this works.
Jose Rojas

"Justin Starnes" wrote in message
...
Is there any way in vba code to reproduce the same functionality in Excel
as
pressing Ctrl+right and/or Ctrl+down? I need a quick way to move to the
last
column and the last row on a spreadsheet.

Also, is there a quick way to convert the worksheet to a string array or
anything else (maybe a dataset)?