Hello,

Sorry maybe for a basic question.
Trying to make a macro within MS Excel (automatic VSB scripting), I get
commands moving the cursor to a particular named cell instead of moving
the cursor to the "right", left etc.

Editing the macro, what are the commands just to let move the cursor to
- right
- left
- up
- down

Ages ago I made some simple macro's in Lotus 123 in such a way the macro
is repetaing itself by moving the cursor over the entire worksheet, to
convert data from horizontal placement, to vertical placement.

E.g. data of 7 coloms horizontal I want to change that the data is over
7 rows vertical. Next data of 7 coloms placed to the 7 next rows etc.

When data is converted to 7 rows each in only one row, I want to save
this as a text-file, so I get data in every single line. 7 lines
contains the data of one "record". Next 7 lines data of the next record.

What I want to do:

- cursor moving one cel down
- insert one row (6 times after each other)
- cursor moving one cel right
- cursor moving one cel up
- cut the entire data
- cursor moving one cel down
- cursor moving one cel left
- past the data in that particular cell
- cursor moving one cel right (2 times after each other)
- cursor moving one cel up
- cut the entire data
- cursor moving one cel down (2 times after each other)
- cursor moving one cel left (2 times after each other)
- cut the entire data
- cursor moving one cel right (3 times after each other)
- cursor moving one cel up (2 times after each other)
- cut the entire data
- cursor moving one cel down (3 times after each other)
- cursor moving one cel left (3 times after each other)
- cut the entire data

etc. till all data of 7 rows is set to 7 lines
- last line is cursor moving one cel down for the next "record"

after that, the macro has to repeat till the complete worksheet is finished.



--
Vr.groet - regards, Léon Obers