VBA command to move cursor

[dhstein]

Is there a VBA command to move the cursor up one row ? Thanks.

 

[Don Guillett]

activecell.offset(-1).select

 

[Gary''s Student]

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

 

[dhstein]

Thanks Gary and Don

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