Microsoft Office Tutorials and References
In Depth Information
Try It
‘Close the With structure of the QueryTable’s Add method.
End With
‘Close the With structure for the destination worksheet.
End With
End Sub
14.
Press Alt+Q to return to the worksheet.
15.
You can test the macro by pressing Alt+F8 to display the Macro dialog box as shown in
Figure 23-8. Run the macro named TimeAfterTime . The result will resemble Figure 23-9.
figurE 23-8
figurE 23-9
To view the video that accompanies this lesson, please select Lesson 23, available
at the following website: www.wrox.com/go/excelvba .
Search JabSto ::




Custom Search