using end and down keys when recording a macro

  • Thread starter Thread starter Marion Gropen
  • Start date Start date
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!
 
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!
 
Back
Top