Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to stop a sub from continueing once a set of values i.e. null in
2 cells is attained. Can anyone help me? Range("A4:w4").Select Do Until ActiveCell.Value = "" 'Moves #1 PM info down until date matches #4 PM date If ActiveCell.Value < ActiveCell.Offset(0, 12).Value Then ActiveCell.Offset(0, 12).Resize(, 11).Insert shift:=xlDown MsgBox "Loop #1 Column A < Column M" 'If #4Pm's date is greater then #1 PM's date then shift #4 down. ElseIf ActiveCell.Value ActiveCell.Offset(0, 12).Value Then ActiveCell.Resize(, 12).Insert shift:=xlDown MsgBox "Loop #2 Column A Column M End If If ActiveCell.Value = ActiveCell.Offset(0, 12).Value And ActiveCell.Offset(1, 12).Value = "" Then MsgBox "A = M AND M = Blank" Kill statement needs to go here End If ActiveCell.Offset(1, 0).Select Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expiring/Killing Macro(s) | Excel Discussion (Misc queries) | |||
Data collation killing me!! | Excel Worksheet Functions | |||
VBA loop is killing me! | Excel Discussion (Misc queries) | |||
Killing the split window | Setting up and Configuration of Excel | |||
Killing Excel :) | Excel Programming |