Select Method of Worksheet Object VBA

Select Worksheet method is used to select a cell or a range(collection of cells). Here we are using Select method of worksheet object to select any cell or a range. It is very frequently used method while writing VBA macros, but before selecting any cell or range first activate cell or that particular range which u want to select. Otherwise sometimes it will fail unless your procedure activates the worksheet before using the Select method of worksheet object.



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

When we use Select Worksheet Method in VBA?

If we want to selects any single cell or collection of cells, then we use select worksheet method. You can use activate method of worksheet object to make a single cell as active cell.

VBA Select Worksheet Method: Syntax

Here is the example syntax to Select Worksheet using VBA. You can use either a Worksheet name or Worksheet number. Always best practice is to use sheet name.

Worksheets(“Your Worksheet Name”). Select(

Sheets(“Worksheet Number”).Select([Replace])

Where Replace is the Optional parameter. When the value is True, it will replace the current selection. When the value is False, it will extend the current selection.
Select is the method of Workbook object is used to makes current sheet as active sheet.

VBA Select Worksheet Method: Example 1

Please see the below VBA procedure. In this procedure we are activating and selecting a Range(“A1”) in the worksheet named “Project1”.

Sub Select_Range()
End Sub

VBA Select Worksheet Method: Example 2

Please see the below VBA code or macro procedure to Select Worksheet. In this example we are activating first Worksheet in the active workbook.

Sub Select_Range()
End Sub

VBA Select Worksheet Method: Instructions

Please follow the below step by step instructions to execute the above mentioned VBA macros or codes:

  1. Open an Excel Worksheet
  2. Press Alt+F11 to Open VBA Editor
  3. Insert a Module from Insert Menu
  4. Copy the above code for activating worksheet and Paste in the code window(VBA Editor)
  5. Save the file as macro enabled Worksheet
  6. Press ‘F5’ to run it or Keep Pressing ‘F8’ to debug the code line by line and observe the selection.

Leave A Comment

Related pages

excel vba tutorialslistbox in userform excel vbaproject management sheet excelalphabetize column in excelhelp with vlookup function in excelxlsm file downloadvba combobox excelhow do you do a tick in excelvba change font sizehide cells excelactivex command buttonexcel advanced macroshow to copy and paste cells in excelexcel formulas tutorial with examplesms excel checkboxunprotect sheet vbapowerpoint donut chartdelete duplicate data excelproject vbavba command button clickexcel vba gotooffset excel functionexcel vba syntaxvba excel codingproject management meeting minutes templatevba code for vlookupexcel vba databasehow do i create a hyperlink in excelexcel vba copy fileproject planning gantt chart excelcolor code in vbavba operatorhow to insert cells in excelwhile loop vbahow to write macros in excel 2007excel 2010 unhide columnsvba sample projectsprompt vbafind duplicates in an excel columnvlookup lock table arrayexcel dashboard add insvba switch statementcolumn width excel vbamacro examples in excelvba not equal toexcel vba activate workbookexcel vba option buttonvba for excel 2007how to prepare pivot table in excel 2010ddl command in sqlhow to merge cells in excel 2013excel save macrohow to declare public variable in vbahow to use autofit in excel 2013macro open excel filedeveloper tab in excel 2007access vba query tableexcel vba new worksheetvba excel if statementgreater than and less than formula in exceldml dclexcel calculate difference between two datesmicrosoft office project plan templatemicrosoft access msgboxvba dir commandhow to merge cell data in exceldml dllvba clipboardcreating dynamic charts in excelexcel 2013 dashboard designexcel vba countif functionsas di tutorialfunctions in excel vbaexcel form vbaddl dml dcl commands in sql serverinserting lines in excelremove duplicates rows in excel