| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i write a macro to move down in the sheet one line ?
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i write a macro to move down in the sheet one line ?
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) "surelystumped" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i write a macro to move down in the sheet one line ?
Thanks. It worked and I see that a minus takes it the other way....
"surelystumped" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get macro to run on any worksheet without renaming the sheet? | Excel Discussion (Misc queries) | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Selecting Last Sheet | Excel Worksheet Functions | |||
| automatic move row from sheet to another | Excel Worksheet Functions | |||
| Macro - Skipping a line | Excel Worksheet Functions | |||
Hybrid Mode
