Thread: [Solved] extending a selection
View Single Post
 
Old 03-05-2021, 05:41 AM
VBAFiddler VBAFiddler is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2021
Posts: 14
VBAFiddler is on a distinguished road
Post extending a selection

Hi,
Not quite sure how to achieve this. I'm searching for a reference or references, they all begin Ref: followed by two digits. This is followed by various characters, and I need to extend the selection to include these.
I assume I need to use "With Selection", and what I want to do is to extend the selection until there is a punctuation mark, or a space. I started by just adding 7 to the .end of a range, but that excluded some and sometimes included bits I didn't want.
I've not included any of my code as I'm not entirely sure where to start with this,
Thanks,
David.
Reply With Quote