I tried the Preview feature and lost the attachment, here it is ...

here is the Macro I wrote to extract the 1st-6 digits of the MA
address for caomparision to the vendor list
-----------------
Option Explicit

Private Sub Analyse_Click()
Dim i As Integer

For i = 1 To 5000
Sheet1.Cells(i, "B") = Left(Sheet1.Cells(i, "A"), 6)

Next i
End Sub
------------------------------

Its not letting me uploadt a 200kb file...well
the column A had all the mac address...for testing purposes..here are
few
0000c5099510
0000c509a113
0000c509b995
0000c509b9f8
0000d12094a1
0001034db20b
0001034db4b8
000103794995
000124701cd3
00012480477f
0001248060ac
000124806101
00012480731e
000124809752
00012480b8bb
00012480d38e
00012480f5d0
000124811b1d
000124812453
00012481672e
000124819605
00012481b2a6
00012481dc07
------------------------
Thank

--
Message posted from http://www.ExcelForum.com