Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-14-2020, 09:04 AM
14spar15 14spar15 is offline Help with setting MySelection Windows 7 64bit Help with setting MySelection Office 2010 64bit
Advanced Beginner
Help with setting MySelection
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with setting MySelection Setting up MS Outlook chester1993 Outlook 2 09-06-2014 08:34 PM
Help with setting MySelection Setting up resources icw Project 2 09-04-2011 03:55 AM
Help with setting MySelection 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft