I have a worksheet wherein I have only 'DATE' value in range of cells, say, A2:V80

Each column has about say 100 rows of data (or instead let the excel-vba code find the used row data, so that each row is considered)

Now, I want a Macro that could

1) Read a Date value from a cell from a Column, say, Column C, Say from Cell 'C2', and put it in an array

2) From the Date in cell 'C2', variable should be made like, 4 days forward, and 4 days backward, so in all I would have 9 variables for cell single c2, like, independant value of cell C2 itself (Variable 1), and 4 days forward (4 Variables), and 4days backward (4variables)

3) Now keeping in mind the value of these 9 variable from cell C2, code should find a similar date (value) (EXACT MATCH), not beyond 10 days from now, rather say, exact match falling due within NEXT 10 DAYS from now, from cell values in each row in alternate column i.e 'Column E' (skiping immediate 'column D'), and then from repeate this process in 'Column G', and so on until column used range i.e. upto 'Column V' in our case

4) Wherever the hit is found, macro should note the date, and its cell location

5) Now this process should go on for each row in 'ColumnC', i.e. it should repeate this procedure for Cell Date value in 'C3',C4,C5, and so on till last used row in Column C, say 'C100' in our case

6) Once this is done with each in 'Column C', same thing should continue with each cell value in 'ColumnD', but it should now compare with data starting from 'Column F', and once done, compare each cell value in Column D, with 'Column H' and so on, untill column data range is over i.e. Column V, in our case

7) AFter this entire loop is over, a Message Box should flash the result with some space i.e. Date, and its cell location, and also highlight the cells in active sheet


I have a sheet wherein I have only DATE value in range of cells, say, A2:V80
Each column have about say 100 rows of data, again only DATES
Now, I want a Macro that could find 'identical dates' that is within the range of say, next 10 days from now, and highlight these identical dates (color the cell), and also flash it in message box with its cell location, like 12/10/2013 in cell M32 or so