Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro doesn't refresh
I have a spreadsheet that I'm trying to wakthrough a list of customers and
print a letter and statement for each. I have a range named 'RowIndex' which is used by VLOOKUP statements and a MS SQLQuery to merge some information. The problem is that it loops through the list just fine but even though I have auto calc on it doesn't seem to refresh the spreadsheet between loops. Any ideas? Code I'm using is below. Sub PrintForms() Dim StartRow As Integer Dim EndRow As Integer Dim Msg As String Dim i As Integer Sheets("PastDueList").Activate StartRow = Range("StartRow") EndRow = Range("EndRow") If StartRow EndRow Then Msg = "ERROR" & vbCrLf & "The starting row must be less than the ending row!" MsgBox Msg, vbCritical, APPNAME End If For i = StartRow To EndRow Range("RowIndex") = i Worksheets("Letter").Activate ActiveWorkbook.RefreshAll ActiveSheet.PrintPreview Worksheets("Statement").Activate ActiveSheet.PrintOut Next i Worksheets("PastDueList").Activate Range("RowIndex").Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I refresh a macro? | Excel Discussion (Misc queries) | |||
refresh macro | Excel Discussion (Misc queries) | |||
refresh macro | Excel Worksheet Functions | |||
Refresh macro | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming |