#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
You can use MySelection.CurrentRegion.Select and then click anyway in the range to select the table (as long as there is nothing around it)
Dont forget to attach example worksheets so that we dont have to try and recreate the test data |
#3
|
|||
|
|||
Paste this into a REGULAR MODULE :
Code:
Option Explicit Sub AutoRngSel() ActiveCell.Offset(, 4).Resize(34, 4).Select End Sub Select the upper left cell of the range to be highlighted .. click the button. |
#4
|
|||
|
|||
I probably didn't explain this exactly right but I was able to use a combination of both of these to get the job done. I like the way that Purfellt uses the active cell as a starting point. I did not need the offset. I combined them with this and it seems to work well for me. Thanks for the help
|
#5
|
|||
|
|||
Glad you have an answer.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting up MS Outlook | chester1993 | Outlook | 2 | 09-06-2014 08:34 PM |
Setting up resources | icw | Project | 2 | 09-04-2011 03:55 AM |
Setting up an account | alexb123 | Outlook | 1 | 07-27-2011 10:55 AM |
Can I get some help setting this up please? | Moiraes Fate | Office | 0 | 05-18-2007 12:22 PM |
setting rules | isapaine | Misc | 0 | 01-11-2006 07:51 AM |