View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
INTP56 INTP56 is offline
external usenet poster
 
Posts: 66
Default Excel Challenge: Compare multiple worksheets macro


Victor,

2 things,

1) You need to pass a column into the function that analyzes the sheets, so
I changed that to 1 instead of 3.

2) I was expecting dupilcates to be in the sheets, and didn't code for what
would happen if there were no duplicates. I test for that case now. I sent
you a new workbook with the code and your data set.

Bob