While writing a macro i found a problem which I can't solve.
On the worksheet is a hyperlink containing a datevalue, this has to change
on a dailybase but while writing the macro it writes down the date in the
macro and it won't change the next time i use the macro.
Does any one know how to solve this problem.

Thanks Gerard