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

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to write a simple copy-paste macro? 4
how do I copy the last 20 entries in an expanding list 4
How do I open a simple one-page Lotus 123 file in Excel 2007? 3
Where do I find the commands for a macro 9
How do I move entire row from one excel sheet to another 3
Enter info in one sheet, auto enter in another based on one field 1
Excel - Summing common cell over mutiple sheets within a file? 5
Move active cell to same location on each worksheet 3

Top