hello:

In lotus we can create a macro to ask us in the middle of the process to
copy to which range. The macro in lotus is like {?} then we sreach the cursor
downward the cell B for example, and then we can copy it to that range.

I want to make in excel similar to it, I want if we hit control D, iin cell
d5 , it will automatically Type "Finished dated 12 Jun 2007"" for today. To
morrow I will put in cell d20 the same word with the tomorrow 's date.

Can anybody teach me how to do it?, The wording of the VBA could be
"Finished" & To day()? or NOW()

Thanks in advance

Frank