Range object is the one of the most frequently used object while automating any task with VBA. We refer different Ranges in Excel Worksheets and perform various operation on Excel Ranges. We have different Properties, Methods to deal with Excel Worksheet Range Objects. Here you can find a brief explanation about each on most useful Properties and Methods while automation any tasks.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

Excel VBA Range Object

Our objective of building this Excel VBA Explorer is to provide suitable examples on most frequently used methods and properties of Range object. So that you can quickly find the solution, syntax whenever you required it.

Range methods helps us to perform different actions with Excel ranges. For example, we can copy a range and paste into different location. And we can insert or delete rows or columns. And we can also clear the ranges, format the ranges.

Excel VBA Range Object Methods:

  • Activate: To activate required Range in Excel Worksheet
  • AddComment: To add Comments in Excel Ranges
  • AdvancedFilter: To apply advanced filters on Excel Range
  • Calculate: To refresh the calculations in a Range
  • Clear: To clear an Excel Range completely including formats and data
  • ClearComments: To clear only the comments in particular Range
  • ClearContents: To clear only the contents/data in a range
  • ClearFormats: To clear only the formats of an Excel range
  • ClearHyperlinks: To clear only the hyperlinks in a Range
  • Copy: To copy a range to another location
  • CopyFromRecordset: Copy the data from recordset and paste in a Range
  • Cut: To cut a Range in Worksheeet
  • Delete: To delete a Range in Worksheet
  • Find: To search and find a cell with required data
  • Insert: To insert a range of Cells, Rows or Columns
  • ListNames: To list the named ranges in the workbook
  • Merge: To merge the Range of Cells
  • PasteSpecial: To paste the data with different criterias, like values, formats with mathematical operations or transpose
Properties of Range object will helps us to deal with various properties of Excel Ranges. For example, we can enter data into a range, read the data from a range, we can change the formats of the range like font color, fill color, borders.

More Explanation and Examples on Properties of Range Object will be available soon.


Leave A Comment

Related pages

dim excel vbaexcel sorting numbersif formula in excel 2007 with examplesample gantt chart templateselect column excel vbamacro templates for excelinsert macro button excelaccess vba examplesexcel nested ifshow do i create a pivot table in excel 2007sum function in vbaexcel vba data analysishow to merge cell data in excelconsolidate excel filesreplace command excelcopy excel cell to another sheetexcel macro combo boxdeveloping dashboardslooping in vbaunprotect excel vba codebest excel vba bookexcel vba set activecellautofit in excel 2013excel macro format cellcreate vbaexcel if cell contains numberexcel macro loopaccess vba opendatabaseexcel find and remove duplicatespopulate combobox excelsample macros in excelline break in vbaif functions in excel 2010excel adovba code to unprotect excel workbookvba cell referenceproject management dashboard excel templateusing case in vbaremove duplicate data excelvba coding in excel for beginnersvlookup with and functionscreen macro recorderexample vba codegenpact finance interview questionscreate a pivot table in excel 2007sql server query examplesumif formula excel 2010create a checklist in excelvba excel dirchart wizard in excel 2010how to unhide columns on excelfinding duplicate in excelhow to merge cells in excellexcel aptitude questionsexcel 2007 hide ribbonhow to dedupe a list in excelexcel append tablesvba code in excel examplestrim function in excel 2007excel macros vbaexcel filter vbaexcel macro range variableexcel 2007 merge cellsms excel formulas 2007excel vba message boxexcel using advanced filterexcel macro loop through sheetshow to remove empty rows in excelexcel option button valuehow do i sort alphabetically in excelpivot table in excel 2007 tutorialenable developer in excelexcel hyperlink buttonactivate macros excelwhat is the meaning of pivot table in excelvba trim functionbasic macro in excelvba rows autofitremove duplicate lines in excel