Range Select

Sometimes, you may need to allow end-users to enter ranges (e.g. “Sheet1!$A$5:$C$10”) by selecting the ranges on the spreadsheet instead of manually typing them. The result or returned value of this feature would be the text representing the address of one or more ranges in a textbox (example of two ranges: “Sheet1!A1:B5,Sheet2!G11”).