It would run only once. See www.cpearson.com/excel/ontime.htm

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


<AKorsakova@gmail.com> wrote in message
news:1147875057.506794.41610@u72g2000cwu.googlegroups.com...
> now with something like RunWhen = date + TimeSerial(23, 59, 59)
> would that automatically refresh every day- or would it just do
> that
> one day?
>