Lotus had a command that allowed you to move the cursor within a macro. The
comand was {r 5} which would move the cursor -right 5- from the current
location. Excell seems to record the keystroke movement into a specific cell
reference within the macro. I see you can do a similar command with
"Selection.End(xlDown)" but I want to move a defined # of cells. not to the
end of a range. Any bhelp would be appreciated.

Ed,

Activecell.Offset(#rows,#columns).Select

So the same as {r 5} would be

Activecell.Offset(5,0).Select

But there is hardly ever any reason to actually select a cell.....

HTH,
Bernie
MS Excel MVP


"Ed" wrote in message
...
Lotus had a command that allowed you to move the cursor within a macro. The
comand was {r 5} which would move the cursor -right 5- from the current
location. Excell seems to record the keystroke movement into a specific cell
reference within the macro. I see you can do a similar command with
"Selection.End(xlDown)" but I want to move a defined # of cells. not to the
end of a range. Any bhelp would be appreciated.

or in the case of moving to the RIGHT
offset(0,5)

--
Don Guillett
SalesAid Software

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Ed,

Activecell.Offset(#rows,#columns).Select

So the same as {r 5} would be

Activecell.Offset(5,0).Select

But there is hardly ever any reason to actually select a cell.....

HTH,
Bernie
MS Excel MVP


"Ed" wrote in message
...
Lotus had a command that allowed you to move the cursor within a macro.
The
comand was {r 5} which would move the cursor -right 5- from the current
location. Excell seems to record the keystroke movement into a specific
cell
reference within the macro. I see you can do a similar command with
"Selection.End(xlDown)" but I want to move a defined # of cells. not to
the
end of a range. Any bhelp would be appreciated.

D'oh! Brain freeze.....

Thanks - at least somebody is reading this...

Bernie



"Don Guillett" wrote in message ...
or in the case of moving to the RIGHT
offset(0,5)

--
Don Guillett
SalesAid Software

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Ed,

Activecell.Offset(#rows,#columns).Select

So the same as {r 5} would be

Activecell.Offset(5,0).Select

But there is hardly ever any reason to actually select a cell.....

HTH,
Bernie
MS Excel MVP


"Ed" wrote in message
...
Lotus had a command that allowed you to move the cursor within a macro.
The
comand was {r 5} which would move the cursor -right 5- from the current
location. Excell seems to record the keystroke movement into a specific
cell
reference within the macro. I see you can do a similar command with
"Selection.End(xlDown)" but I want to move a defined # of cells. not to
the
end of a range. Any bhelp would be appreciated.

I am guilty of these errors often.

--
Don Guillett
SalesAid Software

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
D'oh! Brain freeze.....

Thanks - at least somebody is reading this...

Bernie



"Don Guillett" wrote in message
...
or in the case of moving to the RIGHT
offset(0,5)

--
Don Guillett
SalesAid Software

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Ed,

Activecell.Offset(#rows,#columns).Select

So the same as {r 5} would be

Activecell.Offset(5,0).Select

But there is hardly ever any reason to actually select a cell.....

HTH,
Bernie
MS Excel MVP


"Ed" wrote in message
...
Lotus had a command that allowed you to move the cursor within a
macro.
The
comand was {r 5} which would move the cursor -right 5- from the
current
location. Excell seems to record the keystroke movement into a
specific
cell
reference within the macro. I see you can do a similar command with
"Selection.End(xlDown)" but I want to move a defined # of cells. not
to
the
end of a range. Any bhelp would be appreciated.