View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] courtnml@gmail.com is offline
external usenet poster
 
Posts: 3
Default HELP!! Macro Deletes Last Interval

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!