Using End Sub

[bsnapool]

Hi All

I have the following code:

           End If 
                Else 
                    lRowTo = lRowTo + 1 
                    With wsSumm 
                        .Cells(lRowTo, "A").Value = "Week " & sWeeks(iWeekPtr) 
                        .Cells(lRowTo, "B").Value = "NOT FOUND" 
                    End With 
                   LogEntry ExcelFile:=Filenm, _ 
                            Week:="Week " & sWeeks(iWeekPtr), _ 
                            Message:="NOT FOUND"

What would I use to end this macro???

Thanks for your help in advance...

AQndrew

 

[VoG]

Exit Sub

but I'm not sure what you are trying to do...

 

[bsnapool]

This should explain fully....

http://www.mrexcel.com/board2/viewtopic.php?t=232118

I have tried using simplifying what I want....

Hope somebody can help me...

Thanks