Excel VBA Methods


This entry is part 7 of 9 in the series Excel VBA

Methods are the actions that can be performed against an object. You can think of methods as the verbs. For example, copy. You can copy a cell. When you are programming in VBA, this translates to cell.copy. You put the noun first and the verb second.

Some methods use arguments to further clarify the action to be taken, and some properties use arguments to further specify the property value. In some cases one or more of the arguments are optional.

Some methods have arguments that can dictate how they are applied. For instance, the Paste method can be used more effectively by explicitly defining the Destination argument.

ActiveSheet.Paste Destination:=Range("B1")
Series Navigation<< Excel VBA PropertiesExcel VBA Range Object >>