Excel methods

A method is an action that can be performed with an object. For example, controlling the volume on a television set is a method that can be performed with a real-world object. The behaviour of any object can be controlled by using its methods. If we consider the Range object, you can do things to this object such as Select it to work with in some way, or you can ClearContents (deleting the cells in the range). You can also Copy the contents to the Clipboard, and so on. If we consider another object such as a worksheet, again, you could Select it to work with it, and you could also Delete it -

removing it from the currently open workbook, Protect it - i.e. prevent changes being made to it. Thus, methods, like properties, will differ from object to object, though objects of the same type will clearly share methods.

0 0

Post a comment