Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I write a macro for...
I am trying to record a macro that will:
Open TOOLS Select DATA ANALYSIS Choose REGRESSION and then have the regression dialogue box ready and waiting for me. I yave tried this but when I am in record mode and go through the steps, it is not recording it. Is there something that I need to do to make this happen?? Thanks. Chris |
#2
|
|||
|
|||
Hi
one workaround. Use Sendkeys (have a look at the VBA help for the syntax) -- Regards Frank Kabel Frankfurt, Germany "Christopher Anderson" schrieb im Newsbeitrag ... I am trying to record a macro that will: Open TOOLS Select DATA ANALYSIS Choose REGRESSION and then have the regression dialogue box ready and waiting for me. I yave tried this but when I am in record mode and go through the steps, it is not recording it. Is there something that I need to do to make this happen?? Thanks. Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro help | Excel Discussion (Misc queries) | |||
macro interruption: help!!! | Excel Discussion (Misc queries) |