Macros in Excel : Learn Excel VBA : Methods

This in continution of my earlier post on Macros in Excel : Learn Excel VBA : Objects

Visual Basic is an object oriented language. Objects have methods that perform action on them. In case range is the object you are working upon following methods would perform action on range object

    - Activate
    - Select
    - Cut
    - Copy
    - Clear
    - Delete
    - Paste 

Syntex of many Visual Basis statements is

    Objects.Methods 

Look at the following code to understand the use of methods in VBA

Sub Explain_Methods()
    Range("C4").Copy
    Range("C8").Select
    ActiveSheet.Paste
   
End Sub 

If you are new to Macros in Excel I suggest that you go through earlier posts on Macros
1. Automating Tasks in Excel : Using Macros in Excel
2. Recording Excel Macros / Writing excel macros (VBA)
3. Macros in Excel : Learn Excel VBA : Objects