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
Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking.
ReplyDeleteexcel vba courses london
It's always astounding to witness the depth and breadth of Excel's capabilities, especially when diving into Macros and VBA methods. The intricacies remind me of the precision of a d-sub cable, where every pin and connection has a specific purpose, ensuring that signals are transmitted seamlessly. Just like the efficiency of a d-sub cable in transmitting data, Excel VBA offers unparalleled efficiency in automating and optimizing spreadsheets. Great read!
ReplyDelete