using end and down keys when recording a macro

M

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!
 
R

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!
 
Top