Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two questions
[1] When I run the code with a user form with RefEdit
controls, when I click in the worksheet to highlight cell ranges, the arrow keys, Control-Home key, etc. are not working. Is there a setting that I have to initialize in the code? [2] I am using Application.Run "ATPVBAEN.XLA!Regress" and it works fine. I want to know whether I have to give only Range objects for Y and X range. Can I give array objetcs for Y and X range? Thank you. -- Dileepan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two questions
P.
Re Question [1] - The hotfix here seems to cure the problem... http://support.microsoft.com/?kbid=291110 "XL2000: Cannot Use Keyboard Shortcuts to Select Ranges in RefEdit Control" It also works for XL20002. I don't know about XL2003. Regards, Jim Cone San Francisco, CA http://support.microsoft.com/?kbid=291110 "P. Dileepan" wrote in message ... [1] When I run the code with a user form with RefEdit controls, when I click in the worksheet to highlight cell ranges, the arrow keys, Control-Home key, etc. are not working. Is there a setting that I have to initialize in the code? [2] I am using Application.Run "ATPVBAEN.XLA!Regress" and it works fine. I want to know whether I have to give only Range objects for Y and X range. Can I give array objetcs for Y and X range? Thank you. -- Dileepan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two questions
Re. Question [2]:
The Regress sub only takes ranges, hence the dialog that states "Regression - Input Y range must be a contiguous reference" if you try to pass it an array. Jerry P. Dileepan wrote: [1] When I run the code with a user form with RefEdit controls, when I click in the worksheet to highlight cell ranges, the arrow keys, Control-Home key, etc. are not working. Is there a setting that I have to initialize in the code? [2] I am using Application.Run "ATPVBAEN.XLA!Regress" and it works fine. I want to know whether I have to give only Range objects for Y and X range. Can I give array objetcs for Y and X range? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two questions
-----Original Message----- Re. Question [2]: The Regress sub only takes ranges, hence the dialog that states "Regression - Input Y range must be a contiguous reference" if you try to pass it an array. Thank you for answering my questions. I have a followup. How can I pass an array as a range? Here is a sample code: ============================ For i = 1 To n X(i, 1) = i X(i, 2) = i*i Next AddIns("Analysis ToolPak - VBA").Installed = True Application.Run "ATPVBAEN.XLA!Regress", Range (dataRange), _ X, False, False, , "temp", False, False, _ False, False, , False ============================== The y-range is fine, but X is an array and I am getting an error. How can I pass X as a "contiguous reference"? Thank you, -- Dileepan |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two questions
Write it to a range on the worksheet and then pass that.
-- Regards, Tom Ogilvy "P. Dileepan" wrote in message ... -----Original Message----- Re. Question [2]: The Regress sub only takes ranges, hence the dialog that states "Regression - Input Y range must be a contiguous reference" if you try to pass it an array. Thank you for answering my questions. I have a followup. How can I pass an array as a range? Here is a sample code: ============================ For i = 1 To n X(i, 1) = i X(i, 2) = i*i Next AddIns("Analysis ToolPak - VBA").Installed = True Application.Run "ATPVBAEN.XLA!Regress", Range (dataRange), _ X, False, False, , "temp", False, False, _ False, False, , False ============================== The y-range is fine, but X is an array and I am getting an error. How can I pass X as a "contiguous reference"? Thank you, -- Dileepan |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two questions
As Tom and I both noted, Regress only accepts worksheet cell range
references as input for x and y. Alternately, everything calculated by the ATP regression tool is either directly returned by the LINEST worksheet function, or is easily computable from the values returned by LINEST. You can call LINEST in VBA as Application.LinEst( ) and you can pass arrays to LINEST. Jerry P. Dileepan wrote: How can I pass an array as a range? Here is a sample code: ============================ For i = 1 To n X(i, 1) = i X(i, 2) = i*i Next AddIns("Analysis ToolPak - VBA").Installed = True Application.Run "ATPVBAEN.XLA!Regress", Range (dataRange), _ X, False, False, , "temp", False, False, _ False, False, , False ============================== The y-range is fine, but X is an array and I am getting an error. How can I pass X as a "contiguous reference"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
2 questions. | Excel Discussion (Misc queries) | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
007 questions | Charts and Charting in Excel | |||
2 questions about IF | Excel Worksheet Functions |