I have a large range (upto 60k lines) which I would like to apply a formula too.

A loop would take too long. The formula would apply to info on the row so wouldn't be the same exactly but the row would be the only variable.

What's the best way to do this? I thought I would use VBA rather than Excel to make sure the spreadsheet didn't get too cumbersome.