how do i write a macro to move down in the sheet one line ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to enter into a sheet several lines of information but I can't find
what the equivalent to the Lotus 123 commands for this in Excel Visual
Basic....they would be the down,up, right, and left commands. I thought
selection.down would be it but there isn't such a thing. Where do I find a
list of commands for vb that would be equivalent to Lotus.
 
Selection.Offset(1,0).Select

down 1 row

Selection.Offset(0,1).Select

across 1 column

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top