Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
About my looping
Just started VB for some functions that I would love to realise. but
the onlyu thing that I have for the moment is Sub Macro2() ' ' Macro2 Macro ' Macro recorded 11/07/2007 by STD03 ' ' i = 0 Do While Now() 39269 Range("B5:G7").Select Selection.Copy Range("B13").Select ActiveCell.Offset(i, 0).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False i = i + 3 Loop End Sub B5:G7 is some dynamic data from other database which change irregularly. my code makes it copy and paste in a enormous frequency. what i want to realise is to make it copy every 5 seconds, in order to sotck the data on a regular base. just started VB learning and I have a very short period to make this realised. So hope I can get some help. Thanks a lot in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looping | Excel Discussion (Misc queries) | |||
Looping help please | Excel Programming | |||
looping | Excel Programming | |||
Looping | Excel Programming | |||
Looping | Excel Programming |