How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way ...

Excel will select everything in between, including the two anchor cells. ... I purposely chose a subset because there’s an easier way to select an entire data range: simply press [Ctrl]+[Shift]+8.