![]() |
#4
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
![]() |
PRA007 | Word VBA | 2 | 02-19-2016 12:52 AM |
![]() |
paik1002 | Word VBA | 1 | 12-17-2015 04:51 AM |
Selection (range) in Word or Excel table | NobodysPerfect | Word VBA | 2 | 09-16-2014 12:06 AM |
Selection or Range | Tommes93 | Word VBA | 1 | 04-10-2014 02:50 AM |