Excel中的对象

1,Application 常用属性(ActivateWorkbook,ActiveWorksheet,ActiveCell,DisplayAlerts,StatusBar,DisplayStatusBar,DisplayScrollBar,UserName,Dialogs) Application.Dialogs(xlDialogOpen).Show 常用方法(Quit,Calculate,FindFile,OnTime)

2,Workbooks对象 常用属性(Count,Item,Open,Close) Workbooks("工作簿5").Activate Workbooks(Workbooks.Count).Activate 常用方法(Add,Open,Close)

3,Workbook 常用方法(Activate,Close,Save,SavaAs) 常用属性(ActiveWorkbook,ThisWorkbook,ActiveSheet,Name,FullName,Path,Saved)  

4,Worksheets 常用属性(Count,Visible) 常用方法(Add,Copy,Move,Delete,)

5,Worksheet 常用属性(Cells,Columns,Name,Range,UsedRange,Visible) 常用方法(Activate,Select,Paste,Cut,Move,Protect,)

6,Range 常用属性(Cells,CurrentRegion,UsedRange,Formula,FormulaArray,Name,Value,Count,Offset,RowHeight,ColumnWidth,) 常用方法()

7,Font对象 6,Border对象

原文地址:https://www.cnblogs.com/xyzabc0004/p/2415027.html