richard_brussels
New Member
- Joined
- Jul 25, 2008
- Messages
- 5
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
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