Phone number macro problems

[Poseidons-Palace]

As some maybe aware i am currently working on a large project for my employers who are trying to implement a new computer system see here:

http://www.excelforum.com/excel-prog...06#post2954706

Picture removed!!!

I am currently using the following macro to select the phone numbers, verify if they are landline (both UK and International) and Mobile (UK only)

Please Login or Register  to view this content.

i have tried all sorts but i am now experiencing the following problem:

Picture Removed!!!

What i am really wanting to do is just have two lists one for Landline and one for Mobile but none of them repeated and certainly not the two digit numbers i am getting at the moment.

I am sure there must be a way to do this properly but would accept any advice to get me going in the right direction.

thanks

Jez

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



Do not post pictures of worksheets to the forum. You must post a sample workbook. Describe your problem more clearly.

[Poseidons-Palace]

ProtonLeah: i am unsure what you would have me title the thread as the question is all about a phone number macro that i have created that IS NOT working how i anticipated it should.

What should happen is the macro copies the phone numbers form a list and insert them in the next column as values, from there the next two columns are used to separate the column into the following categories Mobile/Cell Numbers and Landline Numbers. I am then wanting to remove duplicates and empty cells from the two lists and copy them again and paste in the next two columns as values.

I am unable to supply a copy of the spreadsheet as the details contained are strictly confidential, as a great number of our customers are directly Aerospace and Military or there suppliers.

I would welcome a title idea if you can think of an apt one.

Thanks

Jez