Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to get this macro to run but am having trouble:
Public nTime Sub xx() nTime = Now + Time(0, 0, 5) ' 5 secs Application.OnTime nTime, "temp" End Sub Sub temp() Dim iLastRow As Long Range(Range("C2"), Range("C2").End(xlDown)).Copy Range("F2").End(xlDown).Offset(1, 0).PasteSpecial _ Paste:=xlValues, _ Operation:=xlNone, _ SkipBlanks:=False, _ Transpose:=False nTime = Now + Time(0, 0, 5) ' 5 secs Application.OnTime nTime, "temp" End Sub I place it in a standard module but it does not engage. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |