hi

I get a spreadsheet in once a day that has weird dates on it
& they need to be today's date. I've figured out how to do a
macro and save it to a button... but...

I recorded a macro yesterday.. this is what came out

Range("F2").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("F2").Select
Selection.AutoFill Destination:=Range("F2:F1001")
Range("F2:F1001").Select


and I did the same thing today... (forgetting that I'd done it yesterday)

and this is what came out

Range("F2").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("F2").Select
Selection.AutoFill Destination:=Range("F2:F998")
Range("F2:F998").Select


I just want it to do the whole of the F column -- well, not the whole, just
the
values that already exist - and overwrite it with today() -- why does
it put in a fixed range? and more to the point... how do I get it not to?

or is there another way to do it?

please help!

thanks

-JB