View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sheeny Sheeny is offline
external usenet poster
 
Posts: 1
Default 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