Excel VBA - 随笔分类 - Aeol Kong

Excel VBA(3) Ranges

摘要：RangeRange property and shortcut referencesApplication.Range("B2")Range("B2")Range("A1:D10")Range("A1:A10, C1:C10, E1:E10")Range("A1", "D10")Range("Name")Range("A1", Range("Name"))'Shortcut:[B2][A1:D10][A1: 阅读全文

posted @ 2012-02-02 15:17 Aeol Kong 阅读(1126) 评论(0) 推荐(0)

Excel VBA(2) Workbooks and Worksheets

摘要：The Workbooks CollectionSub ActivateWorkbook1() Dim sFullName As String Dim sFileName As String Dim wkb As Workbook sFullName = “C:\Data\SalesData1.xlsx” sFileName = sGetFileName(sFullName) If bIsWorkbookOpen(sFileName) Then Set wkb = Workbooks(sFileName) wkb.Activate Else Set wkb = Workbooks.Ope... 阅读全文

posted @ 2012-01-18 15:03 Aeol Kong 阅读(751) 评论(0) 推荐(0)

Excel VBA(1) Application Object

摘要：The Active Properties ActiveCell ActiveChart ActivePrinter ActiveSheet ActiveWindow ActiveWorkbook Selection Display Alerts Application.DisplayAlerts = False’operations... 阅读全文

posted @ 2012-01-17 12:36 Aeol Kong 阅读(488) 评论(0) 推荐(0)

随笔分类 - Excel VBA