Comparing lists nad printing new/ old in a list box
 

Hi Im really lost and need some help - havent used VB in a few years an
need a refresher...heres what Im trying to do. I know its simple, jus
cant get the

I have two lists, old and new. I used the conditional formatting i
Excel to highlight and bold those in Old that do not appear in New, an
those in New that do not appear in old.

Now, I have two listboxes, one entitled Old and one entitled New.
want to loop through cells A4:A135 and print those that are bold
because they dont appear in New) in ListOld and similarly, want to loo
thorugh cells B4:B135 and print those that are bold in ListNew.

I know this is probably really simple, any help would be GREATL
appreciated.

Thanks so much!!!!!

By the way, Im using Excel 2000

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