#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Please Help

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

"Jenny B." wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"