Application.OnTime

stickyfeet · Mar 23rd 2005

I'm trying to do the following.

Code

Application.OnTime TimeValue(ActiveWorkbook.Sheets("SOD").Range("D3")), "AppStart"

Can someone point me out to where I am going wrong with the syntax please.

(Basically the time of the timed event is taken from a cell on another sheet)

Thanks in advance

SF

**royUK** · Mar 23rd 2005

Re: Application.OnTime

Stickyfeet please use code tags. See my edit. Thanks

stickyfeet · Mar 23rd 2005

Re: Application.OnTime

Oops, my apols, I forgot.

Regs

**royUK** · Mar 23rd 2005

Re: Application.OnTime

Have you checked the similar threads listed above your question?

stickyfeet · Mar 23rd 2005

Re: Application.OnTime

Yes, but theres nothing in relation with having a variable time picked up from a cell on another sheet.

Participate now!