VBA Range object | Excel VBA Tutorials | Part-08

Описание: VBA Range object | Excel VBA Tutorials | Part-08

What is Range object in Excel?
Range is a property in VBA that helps specify a particular cell, a range of cells, a row, a column, or a three-dimensional range. In the context of the Excel worksheet, the VBA range object includes a single cell or multiple cells spread across various rows and columns.

🔴 Subscribe for more videos just like this:    / @robobix  

🎧In this video tutorial, you will learn
How to use range object , method and properties in vba?

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

🖥️Video Summary 👉

Sub CellsExample()
'Cells(3, 2).Value = 10
Range(Cells(1, 1), Cells(1, 5)).Value = 10
End Sub

Sub DeclareRangeObject()
Dim rng As Range
Set rng = Range("A1:E5")
rng.Value = 10
End Sub

Sub SelectExample()
Dim rng As Range
Set rng = Range("A1:E5")
rng.Select
End Sub

Sub RowExample()
Dim rng As Range
Set rng = Range("A1:E5")
rng.Rows(3).Select
End Sub

Sub ColumnExample()
Dim rng As Range
Set rng = Range("A1:E5")
rng.Columns(3).Select
End Sub

Sub CopyPasteExample()
' Dim rng As Range
' Set rng = Range("A1:E5")
' rng.Select
' rng.Copy
' Range("A7").Select
' ActiveSheet.Paste
Range("A7:E11").Value = Range("A1:E5").Value
End Sub

Sub ClearExample()
'Range("A7:E11").ClearContents
Range("A1:E5").Value = ""
End Sub

Sub CountExample()
MsgBox "No of Rows " & Range("A1:E5").Rows.Count
MsgBox "No of Columns " & Range("A1:E5").Columns.Count
MsgBox "No of Cells " & Range("A1:E5").Count
End Sub

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

File Link for practice 👉https://docs.google.com/spreadsheets/...

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

Hope you found this video useful. Please like, share the video and subscribe to our channel. This will motivate us to create more good contents. Thanks!

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🎧Do watch our Other VBA Videos 👉
VBA Code To Change Tab Color of Worksheet | Excel VBA Tutorials | Part-07👉   • VBA To Change Tab Color of Worksheet  | Ex...  
VBA Code To Delete Worksheet | Excel VBA Tutorials | Part-06👉   • VBA To Delete Worksheet | Excel VBA Tutori...  
VBA Code To Protect and Unprotect Workheet | Excel VBA Tutorials | Part-05👉   • VBA Code To Protect and Unprotect Workshee...  
VBA Code To Copy or Move Sheet | Excel VBA Tutorials | Part-04👉   • VBA Code To Copy or Move Worksheet | Excel...  
VBA Code To Grouping of Sheets | Excel VBA Tutorials | Part-03👉   • VBA Code To Group or Ungroup Worksheet | E...  
VBA Code To Hide or Unhide Worksheets | Excel VBA Tutorials | Part-02👉   • VBA Code To Hide or Unhide Worksheet | Exc...  
VBA Code To Add Worksheet's| Excel VBA Tutorial | Part - 01👉   • VBA Code To Add Worksheet | Excel VBA Tuto...  
VBA - Introduction to VBA👉    • VBA Introduction | Excel VBA Tutorial  

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

-------------------------------SOCIAL-------------------------------
🛠️ If you have any doubt or query, drop us an email: [email protected]
👥Facebook: https://fb.me/CodersLobby
📸Instagram:   / coderslobby  
📱WhatsApp : 8558919766
----------------------------------------------------------------------

#vba #vbatutorial #excelvbatutorial #range #rangeobject #rangeinvba #coderslobby #excelvba