Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Dec 9, 10:44*pm, Hong Quach
wrote: Hi courtnml, You need to do a few things to make this code work the way you want. 1. *Change "While ActiveCell < """t to "Do Until ActiveCell = """ 2. *Change "Wend" to "Loop" 3. *Add the following lines after Loop and before End Sub ActiveCell.Value = TimeInv ActiveCell.Offset(0, 1).Activate ActiveCell.Offset.Value = total Hong Quach Checking this out, it looks like its what I am missing for sure. Thanks in advance Hong! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro deletes row in range, macro then skips the row moved up | Excel Discussion (Misc queries) | |||
Macro that deletes every third row....+ | Excel Discussion (Misc queries) | |||
Macro that deletes certain rows only | Excel Programming | |||
Macro That Deletes Columns | Excel Programming | |||
Macro that adds then deletes | Excel Programming |