Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|