Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error when I leave sheet
I have a macro that is set-up on a timer to repeat every 15 secs. When I
click on a different sheet in the workbook I get: Run-time error '1004' Select method of range class failed. Is there a way that I can still work in other worksheets as this macro is running? Thanks, Sub MarketDelta1() ''''''''''''''''' Worksheets("Futures").Range("O2:AA2").Select Selection.Copy Worksheets("Futures").Range("A2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Selection.Insert Shift:=xlDown Worksheets("Futures").Range("O2").Select ''''''''''''''''' ' Call StartTimer to schedule the procedure again If Time TimeSerial(16, 0, 0) Then 'do nothing Else StartTimer End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
an error in a formula in annual leave | Excel Worksheet Functions | |||
Leave a cell COMPLETELY blank if there is an error | Excel Discussion (Misc queries) | |||
Leave Cell Blank if value is an error, below 0 or above 80 | Excel Discussion (Misc queries) | |||
leave sheet event | Excel Programming | |||
Start a sheet event when i leave a sheet | Excel Programming |