Hi Brock,
Quote:
|
I am trying to avoid the userform as then the user, as you noted, will have to select the range.
|
No, a user-selected range isn't the only option. You might be able to determine the range to act on programmatically, independently of what the user might have selected, or use the user's selection as a reference point from which to programmatically determine the range to act on (eg by reference to the page # or document Section that the selection point is in). Without knowing your requirements, it's hard to say what the best approach might be.