Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Help With Worksheet Operations
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)? |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Help With Worksheet Operations
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)? |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Help With Worksheet Operations
Dim vArr as Variant
vArr = ActiveWorksheets.UsedRange.Value for i = lbound(varr,1) to ubound(varr,1) for j = lbound(varr,2) to ubound(varr,2) debug.print i,j, varr(i,j) Next Next Regards, Tom Ogilvy 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)? |
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bitwise operations as in xor | Excel Discussion (Misc queries) | |||
Repeat Operations | Excel Discussion (Misc queries) | |||
how to concatenate operations | Excel Worksheet Functions | |||
OWC operations in Excel | Excel Discussion (Misc queries) | |||
Repeating VBA operations | Excel Discussion (Misc queries) |