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

using sql in excel vbahow to find out the duplicate values in excelprogress chart excel templateediting macros in excelexcel vba messageboxvba entire row deletechange row to column in excelexcel vba arrayspowerpoint dashboard templateshow to use excel lookup functiondelete empty rows in excel 2007vba combo boxisna with vlookupformula vbatrending analysis excelloops in vba excelvba filecopysales analysis template excelvba excel delete columnvba filecopyexcel lookup function exampleshow do i insert a column in excelhide column excelproject costing excel templateawesome excel macrosconcatenate function in excelcomplete excel tutorial pdfintegrated master schedule templatevba form controlsvba accessexcel vba hlookuppivot chart in excel 2010excel vba access queryado connection string sql server 2008auto fit excelvba formuladelete duplicate rowsexcel template plannermsgbox yes no vba accesshow to start vba in excelsql basics commandsformula to find duplicate values in exceladodb connection to access databaseexcel dsninterview questions on sql for freshersprotect a worksheetvba textbox propertieslock spreadsheetproject planning spreadsheetvba excel macrosproject status report template powerpointexcel formula in vbahow to hide and unhide rows in excelloops excelvba as rangevb6 open text fileexcel estimate template constructionms access vba run query with parametersexport access to excel vbaexcel to csv convertervba cellvba create new workbooksumif excelvba caseconnect excel to sql servervba class exampledcl querieswhat is the countif function in excelmicrosoft excel lookup functionvba run macropivot table explainedhow to add a chart title in excelrow vbavba address functionmacro copy and pasteprograming interview questions and answersexcel autorun macrounhide worksheet excel 2010