using end and down keys when recording a macro

[Marion Gropen]

I want to record a macro which will run linest ondata which will have a
variable number of x,y pairs. The macro works on the data field as
originally defined, but does not expand or contract when the data does.
Help!

 

[Ron de Bruin]

One way
Use range Dynamic names in your macro
http://www.contextures.com/xlNames01.html#Dynamic

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




I want to record a macro which will run linest ondata which will have a
variable number of x,y pairs. The macro works on the data field as
originally defined, but does not expand or contract when the data does.
Help!