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

dml commandshow to remove password from protected excel sheetexcel macro codesconsolidate data from multiple worksheets in a single worksheetmatch formula excelexcel countif functionms excel formula with examplehow to delete multiple records in sqlunprotect excel file 2010how to unlock protected excel sheet without passwordhow to duplicate a row in excelapplication filedialog msofiledialogfilepickerhow to increase the column width in exceluserform option buttoncharttitlemacro xlscreateobject vbavba declarationexcel vba built in functionsnested if statements excel 2013excel vba dim workbookbreaking excel password protected sheetvisual basic listboxvba delete cell contentsexcel vba color rgbxls macro tutorialhow to create pivot tables in excel 2007excel unlock macropl sql connect to databasevb basic codesexcel pivotingexcel vba selection objectproject costing template excelunlock excel passwordactivecell in vbaexcel vlookup functionsexcel copy hyperlinkadodb providerunmerge cellsvbscript programs examplesvba listboxvba worksheetfunctionhow to draw pie chart in excel 2007vlookup macro excelexcel spreadsheet examples templatescontains vbaexcel test for empty cellvba convertervba excel activesheetcheck box in excel 2007pivot chart tutorial excel 2010stacked line graph excelvba access excelshortcut key for replace in excelhow to color excel cellswrite macro in excelhyperlink function in excelword and excel test for interviewvlookup in macrohow to remove duplicates in excelexcel visual basic for dummiesexcel row height in inchesunload userformsql dml and ddlexcel vba command buttonvba excel formswot analysis templates for wordexcel vba font colorexcel duplicate recordsif condition in excel 2007vba tutorhow to declare public variable in vbavba sample programsunprotect excel 2010 without passworduse of excel formulas with exampleexcel 3d chartexample for vlookup in excelexcel function trimexcel sorting datesproject charter ppt