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,429
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
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