Help with setting MySelection

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Help with setting MySelection

10-14-2020, 09:35 AM

Logit

Windows 10 Help with setting MySelection

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Paste this into a REGULAR MODULE :

Code:

Option Explicit

Sub AutoRngSel()
    ActiveCell.Offset(, 4).Resize(34, 4).Select
End Sub

You will need a COMMAND BUTTON on the sheet connected to this macro.

Select the upper left cell of the range to be highlighted .. click the button.

Attached Files

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:45 AM.