Gday,

I love this macro stuff it saves me soo much time but unfortunately I havent had any courses on it yet and Im pretty green.

Anyway what I am trying to do is find the row where the date on sheet "Men U_D" is equal to the date in sheet "latest" cell B9. Then do some copying between the sheets ( no need to worry about that) but I'm really struggling with the dates thing any help would be much appreciated.

Regards

Alan O'Connor


Sheets("latest").Range(B9).Select

Dim **** As Date

Set **** = Sheets("latest").Range(B9).Value


Sheets("Men U_D").Select

ActiveWindow.ScrollRow = 1
Range("A1").Select

Do While Cells(x, A).Value <> "****"
x = x + 1