I've just recently upgraded from Excel 2007 to Office 365.
I've written a macro that creates unique reports for a list of recipients (store numbers), looping through until the last and popping up a message box to tell me it's complete.
Here's the code:

Sub CREATE_LIST()
'
' PHARMACY COURSE NOTIFICATION STORES LIST
' Macro written 07/09/2013 by Matthew Mickle

'
    Application.DisplayAlerts = False
    
    'counter = 1
    
    Set srange = ActiveWorkbook.Worksheets("Store_Notifications").Range("H3").Cells
    
    For Each aname In ActiveWorkbook.Worksheets("Store_Notifications").Range(srange).Cells
    
    Sheets("Store_Notifications").Activate
    Range("N2").Select
    ActiveCell.FormulaR1C1 = aname
    
    'counter = counter + 1
    
    'MsgBox "Report " & counter
    
    Call Mail_Store
    
    Next

'Sheets("Email").Activate

MsgBox "The Pharmacy Course Notification Reports have been sent."

'Call PHARM_NOTIFICATION

End Sub
The code works...the problem is that it seems to shut down after building approximately 1/2 of the reports and sending them. It doesn't error out, it just ignores the last 30 or so of the 60 reports I'm creating, even popping up the "I'm complete" message when finished. No error, no debugging, just ignoring part of the variable srange.

The code works (creates all 60 of the reports) IF i activate the counter lines and press OK in between each report, but that almost defeats the purpose of the macro.

Any ideas?