Dim VendorCol As Integer, VendorNameCol As Integer
VenderNameCol = 16 'this is the column that the actual name is in

Note the typo in the second line.
This means that VendorNameCol has the default value of 0, not 16

Doh! Good point. Last time I borrow a bit of code without knowing
what each line precisely does ...

(well, probably not. But it's a good learning experience!)

Thanks!!! Will test it out, should work with that correction, since
that makes a LOT of sense (the 0 column is probably blank ... and the
VendorCol was correct and thus doing the right number ;)

-Joe


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