If it were me, I'd add a named range that contains the last time the macro
was run. Each time the macro is run, I'd pull that value and do the
calculation. After the calculation is done, I'd reset the named range. If
you need more info on this, come back and let us know.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Mr. Clean" wrote:

Excel 2003 VB - I need to add code to a macro that compares today's date to
the last time this macro was run, and provides the number of days different
between the two dates.

Can anyone help?