Thread: Macro problems
View Single Post
  #3  
Old April 20th, 2010, 11:21 PM posted to microsoft.public.excel.misc
Pierre
external usenet poster
 
Posts: 223
Default Macro problems

Hi.

You would need to define your starting point as a variable, not a specific
cell.



"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

(My apologies if this is duplicated as I cannot see the original post after
12 hours)

.