View Single Post
 
Old 10-14-2020, 09:04 AM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Help with setting MySelection

Hello, I am using this to select my selection.

Set MySelection = Application.InputBox(prompt:="Select a range of cells", Type:=8)

My range is always 4 columns wide and 34 rows deep. Rather than selecting this 4x34 selection each time, could this line be modified so that I would always just pick the single top left cell of my desired 4x34 selection and MySelection would end up being the complete 4x34 selection based off the selected cell. Thank You
Reply With Quote