Range method 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. Explore the various methods and examples on Excel VBA Range using side navigation. Below are the most frequently used Excel VBA Range methods.



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 Object11

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

Leave A Comment

Related pages

cell address vbasort excel column alphabeticallyvba select case examplematch function in vbaexcel 2007 workbookvba toolsexcel consolidationunhide cellvba select sheethow to program a macro in excelvba array definitionddl dml commandsproject mobilization plan sampleexcel workbook passwordhow to add a drop down list in excel 2007vba data validation listvba workbookshow to protect excel with passwordfind duplicate values in excelmacro programming in excelpivot chart excel 2007powerpoint macro tutorialuseful vb scripts for windows 7break loop vbavba insert blank rowhow to create vlookup in excel 2007excel merge sheets by columnexcel unhide alldim string vbasql dml commands with exampleshow to change the row height in excel 2010how to do vlookup on excel 2010vba macro tutorialwriting excel macrosvlookup duplicateshow to combine cells in excel 2007vba line feed charactervb script excelexcel vba with selectioninterview questions and answers for fresherhow to filter duplicates in excel 2007vba excel objectwriting a macro in excelproject tracker template excel freevba entirecolumnexcel vba getsaveasfilenamesum if excelthe tutorial on excel macros vbacommon excel commandsado connectionoffice move checklist template excelmacros databasehow to connect cells in excelexcel presentation templatesexcel vba select rowscount columns exceluse of vlookup in excel 2007left excel vbadaily gantt chart excel templaterefresh excel sheetinsert a new worksheetms access remove duplicateshow to remove blank cells in excel 20103d cluster chart excelcreate excel workbookunprotect excel workbook with passwordexcel vba delete multiple rowsexcel offset functionexcel project timeline templateshow to remove duplicate rows in excel 2003insert check boxexamples of spread sheetssave xlsm as xlsxvba checkboxexcel task management template freedrop down lists in excel 2007excel hidden columninsert check box excelbox plot excel 2010 templateexcel 2013 dashboard design