automatically refresh macro

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Do you know if it is possible to program a macro button
to automatically refresh once per day? My macro formula
is:
Range("y7").value=Range("x7").value
Range("x7").value=Range("w7").value
Range("w7").value=""

I would like this to occur once per day at approximately
5pm. Thanks for your help.
 
I tried to use
=x7
and
=w7
however w7 is a stock quote web query and therfore x7
will take on the query and not the value. Perhaps there
may be another way to do this that I have overlooked?
Thanks again.
 
Back
Top