Loop formula through columns

[tikktakk]

Hi!

I am not very good at writing macros, but I have found that you can often make useful macros by googling and pasting code from the web. Now I have a task that I find difficult to solve and it would be great if someone could help me. I need to use a formula and loop it through about hundered colums on a sheet.

Something like:

CORREL(A2:A100;B2:B100) ..loop to.. CORREL(A2:A100;Q2:Q100)

All the results from the correl-formulas should be inserted in a new column on another sheet.
The problem I have is that I don't know how to loop through a set of columns in a formula. Any help would be very much appreciated!

[JOHN H. DAVIS]

This will loop through rows 2 to 100 and columns 1 to 43 and place a formula in each cell. variable x is the row count and variable i is the column count.

Please Login or Register  to view this content.

Hope that helps.