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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting cell contents into a macro 1
Recording Regression in Macros 1
Data exchange between macro and spreadsheet 1
Run a macro only for the selected fields(records) 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Run a recorde macro in multiple excel workbook at a time 3
pivot table macro with a filtering variable 3
Cell referencing in Macros 5

Back
Top