Thread: How to get start and end range indices of a selection
View Single Post
 
Old 07-02-2017, 06:21 AM
gmaxey gmaxey is offline Windows 7 32bit Office 2016
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default
Provided something doesn't happen to drop the variable out of scope something like this perhaps:

Code:
Option Explicit
Private oRng As Range
Sub SetSelection()
  Set oRng = Selection.Range
End Sub
Sub Reselect()
  oRng.Select
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote