Re: macro row movement
- From: "Bob Phillips" <bob.ngs@xxxxxxxxxxxxx>
- Date: Sat, 28 Jun 2008 16:56:29 +0100
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
news:emua64t8ka9c258p7mh7l7ibob254f9269@xxxxxxxxxx
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
<inflnow@xxxxxxxxxxxxxxxxxxxxxxxxx>
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" <inflnow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:99C8663B-B3D7-450A-8A95-19D2C687410E@xxxxxxxxxxxxxxxx
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?
.
- References:
- Re: macro row movement
- From: Bob Phillips
- Re: macro row movement
- From: Gord Dibben
- Re: macro row movement
- Prev by Date: Re: Functions in Name Box
- Next by Date: Re: How can I say "If cell value is > 1700 but < 2599, then * .25 else
- Previous by thread: Re: macro row movement
- Next by thread: Re: MROUND
- Index(es):
Relevant Pages
|
