Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting a Loop
Hi,
I'm trying to loop the code below until row 38, I basically want it to check B8 with V8, B9 with V9 etc but i cannot for the life of me remember how to loop this. I want an error box to appear when it finds an error and when this happens i want the loop to stop. Any help would be appreciated Private Sub Workbook_BeforeClose(Cancel As Boolean) With Worksheets("Price Change") If Range("B8").Value = "" And Range("V8").Value < "" Then MsgBox "You cannot enter a date when there is not a code to change price" Cancel = True End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |