-
Get index using RegExp
I've created some code to display selected photographs based on their index number in a report. The way the report is constructed lists the photo refernces within brackets, which may be in any of the following forms. The report is 300+ pages with 5,500 photo references, so a bit of a problem to "regularise".
(X078)
(A078/A079/A080)
(X078, X079)
(AB078 - AB083)
I would like to "extract" the reference number by running the macro when the insertion point is within the reference.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules