Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: stephenjones
- Order by date
-
Using Correlation Analysis in a macro??
Skip- Not sure what the second range would be, its a correlation so you only have an input range and then a cell to paste the results. Also, the code that you gave, should that be in a FUNCTION or SUB?- stephenjones
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using Correlation Analysis in a macro??
Skip- Thanks for the help. However, I want the macro to run the correlation, then paste the values in cell A27. This part of the macro is part of a larger macro. I used the recorder and that was the code it developed. Why doesn't it run?- stephenjones
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using Correlation Analysis in a macro??
I have a macro (see below) that should select the range of cells, then run the "correlation" tool from the data analysis add-in (TOOLS < DATA ANALYSIS < CORRELATION), but it doesn't work. Sometimes I get an error that says it can't find the ATPVBAEN.XLA!Mcorrel file. Now, I get no...- stephenjones
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
