Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell using VBA
Range("A2").End(xldown)
want to select next cell :confused -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell using VBA
Hi
you can use Range("A2").Offset(1, 0).Select to move down one row or ActiveCell.Offset(1,0).Select Cheers JulieD "anupam " wrote in message ... Range("A2").End(xldown) want to select next cell --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell using VBA
Range("A2").End(xldown)(2).Select
-- Regards, Tom Ogilvy "anupam " wrote in message ... Range("A2").End(xldown) want to select next cell --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to next cell using VBA
Hi,
Another way: Range("A2")(2).Select or ActiveCell(2).Select -- Regards, Soo Cheon Jheong _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move from cell A 10 to cell B1 with one move or click | Excel Worksheet Functions | |||
Arrow keys move screen instead of moving from cell to cell | Excel Discussion (Misc queries) | |||
formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
How do I make my arrow buttons move from cell to cell in Excel? | Excel Discussion (Misc queries) |