Thread: InputBox selects rows
View Single Post
 
Old 08-31-2016, 06:09 PM
Dave T Dave T is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default InputBox selects rows
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
Reply With Quote