Macro to insert cell values into formula

[richard_brussels]

Hi,
I'm having difficulty making a formula within VBA.
I want to enter the column and number of rows as variables, then read in the data, then make a formula using this data.

eg. B3:B6 2
3
4
5

B2 = choose(A2,2,3,4,5)

I want to do this on multiple columns on multiple sheets with many rows each time - therefore typing the formula is not an option!
Also I want to use these formulas in other books, therefore I want the "choose" formula rather than using a "lookup".

Thanks for reading