Prev: Excel slow!
Next: league table sort
From: Father John on 20 Apr 2010 07:24
Hi I am trying to record a simple macro where if I press alt+d the location
moves 7 "page down" key strokes - about 100 rows.
However when I record the macro it resorts back to the line number that my
macro originally ended up at 7 keystrokes from the top., even if I am 1500
lines down.
How can I resolve this?

With thanks
Stephen

From: Mike H on 20 Apr 2010 08:14
Hi,

I'm a bit dubious of statements like

> moves 7 "page down" key strokes - about 100 rows.

particularly in relation to code which doesn't normally deal in 'abouts',
it's generally more precise than that. However how about running this with
you ALT +D shortcut

Sub Move_Down()
ActiveCell.Offset(100).Select
End Sub


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Father John" wrote:

> Hi I am trying to record a simple macro where if I press alt+d the location
> moves 7 "page down" key strokes - about 100 rows.
> However when I record the macro it resorts back to the line number that my
> macro originally ended up at 7 keystrokes from the top., even if I am 1500
> lines down.
> How can I resolve this?
>
> With thanks
> Stephen
>
> .
>
 | 
Pages: 1
Prev: Excel slow!
Next: league table sort