Hi Mordred,
You can extract the v654321 number using VBA string functions. There are a lot less of them than in Excel. Find the list at: http://www.techonthenet.com/excel/fo.../index_vba.php
This site shows how to convert cell functions to VBA.
If you need help extracting the string between ( and ) using vba please reply to this and I'll do it.
Bookmarks