Please Help

J

Jenny B.

Hello,

I just posted not long ago asking for help creating a timer. I've created
one that works (should say worked), but I'm now getting an error and
wondering if you could provide some assistance.

The below calls for the Macro FNINE to run every 15 seconds (which it did
until an error came up after a certain amount of usage). The Macro FNINE is
simply what it sounds like - F9 to refresh the screen. The error is as
follows - The macro "C:\Documents and Settings\usccu044\Destop\2007 Sales
Expansion Steps.xls'!update' cannot be found.

Sales Expansion Steps is the name of my Spreadsheet and it's saved to my
desktop which is also noted in the above code. The worksheet is still
operating fine, but when I click to set this Macro in motion (see below) -
it gives me the mentioned error after every 15 second interval - I just don't
get it.

Thanks for any helps with this - Jenny B.

Sub timer()
Dim nextick
Call fnine
nexttick = Now + TimeValue("00:00:15")
Application.OnTime nexttick, "update"
End Sub
 
T

Toppers

Where is the macro "Update" which called by the last statement?

Or should "update" be "fnine"?

Sub timer()
Dim nextick
nexttick = Now + TimeValue("00:00:15")
Application.OnTime nexttick, "fnine"
End Sub
 
D

dksaluki

Is your code in the SHEET1 Object?, or is it in a Module? I had a
similar problem, then cut/pasted all my code to a module and it worked
fine after that.

DK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Stop the clock 2
clock on user form 6
Application.OnTime 2
Stop timer. 7
Macro Loop 0
EXCEL 2003 MACRO Problem 1
Elapsed times > 24hrs 12
How do i stop a clock in excel 0

Top