VBA command to move cursor
in [General]
|
From: dhstein on 28 Mar 2010 08:15 Is there a VBA command to move the cursor up one row ? Thanks.
From: Don Guillett on 28 Mar 2010 08:23 activecell.offset(-1).select -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "dhstein" <dhstein(a)discussions.microsoft.com> wrote in message news:00256E75-D9D8-4A27-9909-F1667553FC35(a)microsoft.com... > Is there a VBA command to move the cursor up one row ? Thanks.
From: Gary''s Student on 28 Mar 2010 08:41 If you mean move the Activecell up one row, then: Sub MoveUp() ActiveCell.Offset(-1, 0).Select End Sub If you mean actually moving the mouse in VBA, then start here: http://msdn.microsoft.com/en-us/library/ms171548(VS.80).aspx -- Gary''s Student - gsnu201001 "dhstein" wrote: > Is there a VBA command to move the cursor up one row ? Thanks.
From: dhstein on 28 Mar 2010 12:55 Thanks Gary and Don "Gary''s Student" wrote: > If you mean move the Activecell up one row, then: > > Sub MoveUp() > ActiveCell.Offset(-1, 0).Select > End Sub > > If you mean actually moving the mouse in VBA, then start here: > > http://msdn.microsoft.com/en-us/library/ms171548(VS.80).aspx > > -- > Gary''s Student - gsnu201001 > > > "dhstein" wrote: > > > Is there a VBA command to move the cursor up one row ? Thanks.
|
Pages: 1 Prev: Why do I get VLookup error 1004 Next: ActiveCell.FormulaR1C1 |