Help With Worksheet Operations
Thanks!
Justin
"Jose Rojas" wrote in message
...
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)?
|