Need help for a code in macro (to identify alpha numeric numbers)

Hi,

I am preparing a macro which identifies and copies 9 digit alpha numeric code (alpha till 4). The code am using is "\b\w{0,9}\d{4,9}\b"

But this code is copying alpha numeric numbers more than 9 too.....

I need to prepare a macro which would take only 9 digit numbers (including alphabets till 5)

My full macro code is

Please Login or Register  to view this content.

I am attaching the txt file from which this macro should copy the numbers. thanks

1) Not recommend "Match" for variable name as it is a reserved word for VBA
2) If 9 digits numbers only, Pattern should be "\b\d{9}\b"
I would write like this

Please Login or Register  to view this content.

When you post the code, use the code tag
e.g

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Hello Raju Radhakrishnan,

I added code tags to your post. This keeps your original formatting, making it easier to read, and easier to copy. Please do this in future posts. If you don't know how, see my signature line.