Darren,

have a look at ONTIME in Excel VBA help

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Darren" wrote:

I have a macro that draws data from a website and places in to several tables
which are then organised is different criteria. Instead of me manually
hitting the button with assigned macro, I want to have the macro run itself
every 10 minutes. How do I do this please?