sumsaam
Board Regular
- Joined
- Dec 31, 2012
- Messages
- 82
- Office Version
- 2010
- Platform
- Windows
Hi
i have 10 named ranges in sheet11 and in sheets to 1-10 i want a list box or combo box with names of 10 ranges on every sheet. which range i select, excel should show selected range on that sheet. code may be given for 2 or three ranges i will convert it for 10 ranges. thank you
i have 10 named ranges in sheet11 and in sheets to 1-10 i want a list box or combo box with names of 10 ranges on every sheet. which range i select, excel should show selected range on that sheet. code may be given for 2 or three ranges i will convert it for 10 ranges. thank you