I am trying to write a macro that includes the "correlation" function from the data analysis toolpack.
I have data that is constantly updating in rows (the number of rows changes randomly) and columns (the number of columns changes randomly). I would like to write a macro that eliminates the manual work of having to use the corelation function and resize the rows and columns.
I need it to do the following:
1) resize the number of row
2) resize the number of columns
3) run the correlations
I used the record macro function and the only output I got was:
Application.Run "ATPVBAEN.XLA!Mcorrel", , , "C", False
I cant make any headway with this. I tried using MSFT help and searching this board.
--please advise
I have data that is constantly updating in rows (the number of rows changes randomly) and columns (the number of columns changes randomly). I would like to write a macro that eliminates the manual work of having to use the corelation function and resize the rows and columns.
I need it to do the following:
1) resize the number of row
2) resize the number of columns
3) run the correlations
I used the record macro function and the only output I got was:
Application.Run "ATPVBAEN.XLA!Mcorrel", , , "C", False
I cant make any headway with this. I tried using MSFT help and searching this board.
--please advise