Read application.ontime then

"Jacob_F_Roecker" wrote in message
...
OK I think that I've got the record for the WORST code EVER.

I wanted to build a spreadsheet that would automatically become a webpage.

I built the macro and I was good. COOL BEANS

But I wanted excel to do that every minute...because it referenced a
external data that updated every minute.

I got it to work the WORST possible way you could imagine for code and
speed.

I told it to calculate the difference between two cells--each of which
were
times/dates.

Basically my Macro is continuously running the =now() on one cell until
it's
been a minute and then it runs the other code.... starts all over and does
it
again.

I KNOW there are more efficient ways of doing this but google didn't point
me to anything I could understand.

Someone mind writing me and letting me know the BEST way to do this? I'm
game for some reading.