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?

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?

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?

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?

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?