Move to next cell using VBA

[anupam]

Range("A2").End(xldown)

want to select next cell

:confused

 

[JulieD]

Hi

you can use
Range("A2").Offset(1, 0).Select
to move down one row
or
ActiveCell.Offset(1,0).Select

Cheers
JulieD

 

[Tom Ogilvy]

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

 

[Soo Cheon Jheong]

Hi,

Another way:

Range("A2")(2).Select

or

ActiveCell(2).Select


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