ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 304
- Office Version
- 2016
- Platform
- Windows
I have a very complicated Question. The only way around that I can see is using 7 If,s
I am happy with a simple VBA formula or a way to name the ranges
I have seven different ranges, and depending on the users input I want to select given ranges.
If users selects Option 1 I want to select 7 ranges. A1:A4, A10:A14,A20:A24, A30:A34, A40:A44, A50:A54, A60:A64, A70:A74
If users selects Option 2 I want to select 6 ranges. All the options except the last.
If users selects Option 3 I want to select 5 ranges. All the options except the last2.
All the way up to user selecting option 7 and only A1:A4 would need selecting
I can't make a table and use a lookup.
Any help would be appreciated
I am happy with a simple VBA formula or a way to name the ranges
I have seven different ranges, and depending on the users input I want to select given ranges.
If users selects Option 1 I want to select 7 ranges. A1:A4, A10:A14,A20:A24, A30:A34, A40:A44, A50:A54, A60:A64, A70:A74
If users selects Option 2 I want to select 6 ranges. All the options except the last.
If users selects Option 3 I want to select 5 ranges. All the options except the last2.
All the way up to user selecting option 7 and only A1:A4 would need selecting
I can't make a table and use a lookup.
Any help would be appreciated