VBA .
:
Object.Method
, , :
Object.Method Argumentl, Argument2, Argument3...
Object ;
Method , , ;
Argument1, Argument2 . VBA, , . ; .
4. Excel Activate, . ThisWorkbook , :
ThisWorkbook.Activate
Activate , , SaveAs Excel; :
ThisWorkbook.SaveAs Filename:="C\Temp\NEWFILE.xls"
3. Excel VBA
Activate | Window, Workbook, Worksheet, Range . | |
Calculate | , | Application, Range, Worksheet |
Clear | , | Range |
Close | Window, Workbook, Workbooks | |
Justify | , | Range |
Run | Application, Range | |
Save | Application, Workbook | |
SaveAs | Workbook, Worksheet | |
Select | Range, Sheets, Worksheets | |
SendKeys | host- | Application |
Volatile | Application |
5. Clear
Sub TestMethodsOl()
' Clear
' Clear
MsgBox ActiveCell.Formula,, " Clear"
' Clear
ActiveCell.Clear
'
' Clear
MsgBox ActiveCell.Formula,, " Clear"
' :
Range("C6:D7").Clear
End Sub