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!
|