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 ...
VBA Code To Delete Worksheet | Excel VBA Tutorials | Part-06👉 • VBA To Delete Worksheet | Excel VBA T...
VBA Code To Protect and Unprotect Workheet | Excel VBA Tutorials | Part-05👉 • VBA Code To Protect and Unprotect Wor...
VBA Code To Copy or Move Sheet | Excel VBA Tutorials | Part-04👉 • VBA Code To Copy or Move Worksheet | ...
VBA Code To Grouping of Sheets | Excel VBA Tutorials | Part-03👉 • VBA Code To Group or Ungroup Workshee...
VBA Code To Hide or Unhide Worksheets | Excel VBA Tutorials | Part-02👉 • VBA Code To Hide or Unhide Worksheet ...
VBA Code To Add Worksheet's| Excel VBA Tutorial | Part - 01👉 • VBA Code To Add Worksheet | Excel VBA...
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