View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Compare 2 Lists and Take an Action Q

If you have headers, change the code:

I'd leave the headers included in the 2D arrays, just start at row2...

For i = 2 To LBound(varA)
For j = 2 To LBound(varB)

...so no row offset is required!!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion