I am not sure how to do this within a VBA macro.

The whole routine is generating a 7-day period report based on the date entered in one cell. On entering the date the macro will generate a report containing all the necessary production statistics for the 7 days preceding the entered date, the rows of production data I am trying to identify are just one part of a more comprehensive report.

Rgds,
Jon