Vlimit = Cells(Rows.Count, 1).End(xlUp).Row 'count across to the column containing the tasks - tells Excel to count how many rows of data

Print out the contents of a cell which you want to ignore, count how many Rows and then Coloums the cell is at and enter in r,c formatĭebug.Print 'value = ' & Cells(2, 9).Valueĭebug.Print 'colour = ' & Cells(2, 9).Interior.ColorIndex Sub Dates_from_colours_not_grey() ' return date values into cell if the cell is not a grey colour (colour index = 2) Into this area, copy the code below, from Sub to End Sub inclusive. Excel will display a blank white space to the right. Select your file from the list on the left (if it isn’t already selected) and click on the Insert Menu and choose “module”.

Bring up the VBA Window by pressing the and keys.