Move to next cell using VBA
 

Range("A2").End(xldown)

want to select next cell

:confused

--
Message posted from http://www.ExcelForum.com

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

:confused:


---
Message posted from http://www.ExcelForum.com/

Move to next cell using VBA
 

Range("A2").End(xldown)(2).Select :rolleyes:

--
Regards,
Tom Ogilvy

"anupam " wrote in message
...
Range("A2").End(xldown)

want to select next cell

:confused:


---
Message posted from http://www.ExcelForum.com/

Move to next cell using VBA
 

Hi,

Another way:

Range("A2")(2).Select

or

ActiveCell(2).Select


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--