using end and down keys when recording a macro
 

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!

using end and down keys when recording a macro
 

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)
www.rondebruin.nl



"Marion Gropen" wrote in message ...
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!