macro row movement
 

In Excel 2003 macro, how do you tell the macro recorder to record the action
of "move down three cells from the current cell."
Using the down arrow key places a cell reference and this won't work for me.
Using the "Enter" key pastes from my clipboard so that does'nt work. What
is the simple solution?

macro row movement
 

Activecell.Offset(3,0).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"inflnow" wrote in message
...
In Excel 2003 macro, how do you tell the macro recorder to record the
action
of "move down three cells from the current cell."
Using the down arrow key places a cell reference and this won't work for
me.
Using the "Enter" key pastes from my clipboard so that does'nt work. What
is the simple solution?

macro row movement
 

Bob, you're the best. You saved me 2 weeks of growing very old. In the (3,0)
would reversing direction equate to (-3,0) and is the 0 column movement?

"Bob Phillips" wrote:

Activecell.Offset(3,0).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"inflnow" wrote in message
...
In Excel 2003 macro, how do you tell the macro recorder to record the
action
of "move down three cells from the current cell."
Using the down arrow key places a cell reference and this won't work for
me.
Using the "Enter" key pastes from my clipboard so that does'nt work. What
is the simple solution?

macro row movement
 

Yes

-3 would move up 3 rows.

The 0 is the column designation in the Offset(3, 0)

Offset(0, 3) is same row, 3 columns to right.


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 09:28:03 -0700, inflnow
wrote:

Bob, you're the best. You saved me 2 weeks of growing very old. In the (3,0)
would reversing direction equate to (-3,0) and is the 0 column movement?

"Bob Phillips" wrote:

Activecell.Offset(3,0).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"inflnow" wrote in message
...
In Excel 2003 macro, how do you tell the macro recorder to record the
action
of "move down three cells from the current cell."
Using the down arrow key places a cell reference and this won't work for
me.
Using the "Enter" key pastes from my clipboard so that does'nt work. What
is the simple solution?

macro row movement
 

But be careful when you set an offset that you have room to reference that
offset. For instance, if B2 is the activecell, Offset(-2,0) will throw an
error.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Yes

-3 would move up 3 rows.

The 0 is the column designation in the Offset(3, 0)

Offset(0, 3) is same row, 3 columns to right.


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 09:28:03 -0700, inflnow

wrote:

Bob, you're the best. You saved me 2 weeks of growing very old. In the
(3,0)
would reversing direction equate to (-3,0) and is the 0 column movement?

"Bob Phillips" wrote:

Activecell.Offset(3,0).Select

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"inflnow" wrote in message
...
In Excel 2003 macro, how do you tell the macro recorder to record the
action
of "move down three cells from the current cell."
Using the down arrow key places a cell reference and this won't work
for
me.
Using the "Enter" key pastes from my clipboard so that does'nt work.
What
is the simple solution?