Hello All,

Not quite sure if an InputBox is the right approach, but I am at a loss on how to do this.

I have a range of data between columns A to K and I have been looking for a way for a user to use something like an InputBox the select any range of cells within a column and the data between columns A to K is selected.

Basically if a user selects a range of cells in any column between A to K the macro will select the data in the rows between columns A to K.

It would be nice if a user selected a range of cells between columns A to K it would still select all the data between A to K

• If A10:A20 is selected via the InputBox then A10:K20 will be selected
• If G10:G20 is selected via the InputBox then A10:K20 will be selected
• If A10:E20 is selected via the InputBox then A10:K20 will be selected

Regards,
Dave T