The Selection object represents the current selection in the worksheet. Selection is usually, and for our purposes always, a Range object. Rewrite the subroutine in exercise 6 so that it works on a selected range.

Note the following:

If the selected range is a single cell, activate the subroutine in exercise 6.

If the selected range is a column, activate a subroutine repeatedly for all cells in the column.

If the selected range is more than one column, the subroutine should abort with an appropriate message.