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

project calendar template excelexcel combo box vbaunhide a row in excel 2010outlook meeting minutes templateadvanced filtering excel 2013how to unhide the first column in excelexit loop vbalocking cells in excel 2007dcl tclms excel formulas 2007tools in excel 2007 macro securityexcel 2010 sumif functiondelete row in excel vbaexcel vba averageremove duplicate entries from excelaccess vba file existsrange.find vbaspotfire script examplesvlookup function with examplehard return in excelexcel macro create folderexcel visual basic macrovba programming in excel 2007h look up in excelhow to use the countif function in excel 2013vba sortvba timer examplevba workbook activateexcel hyperlink to celldim vbaexcel inputboxhow to put columns in alphabetical order in excelaccess query vbavba cell valueexcel application.matchwhat is meant by vlookup in excelsimple excel macrosave excel vbakpi excel dashboardmsg in vbasas basics tutorialvba insertaccess vba run macroexcel vba report generatorexcel hyperlink to sheetunhide worksheetquery sql database from excelaptitude test questions and answers for freshers pdfvba excel iferrorexcel vba open word documentmicrosoft excel construction schedulevba end loopif functions in excel 2013creating dashboards in excelvba range objectaverageif excel 2010excel project gantt chart templateunlock excel password protected fileqtp basics pptremove blank lines excelpassword protect xlssimple vlookup examplevba saveassas mainframe tutorialhow to unhide a sheet in excelcase select vbavlookup function examplehow to unhide all sheetsinterview questions on sql queries with answers pdfloop through worksheets vbaupdate screen vbaunprotect excel sheet forgot password