Macro error

[Father John]

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

 

[Mike H]

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.