Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm new with loops and I can not seem to exit this loop. The loop works in
notifying the user there is no more data (by way of msgbox). But when I click Okay on the box, it just stays there. So I'm thinking the loop is not exiting properly. Can you help me exit this loop. Thanks. Sub printfromqueue() Dim usrid As String Dim sh As Worksheet Dim rng As Range Dim bk As Workbook Dim cell As Range usrid = Environ("Username") Set sh = Workbooks(usrid & ".xls").Worksheets("Sheet1") Set rng = sh.Range(sh.Cells(1, 1), sh.Cells(1, 1).End(xlDown)) For Each cell In rng If cell.Value < "" Then Set bk = Workbooks.Open(cell.Value) finalizequeue 'print macro bk.Close savechanges:=False Else: MsgBox ("no more data"), vbOKOnly End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
do while loop problem | Excel Discussion (Misc queries) | |||
Problem with Do Loop and If | Excel Programming | |||
For Next loop problem | Excel Programming | |||
Loop Problem | Excel Programming | |||
For..Next loop problem | Excel Programming |