![]()
This helps you to accessing workbook or sheet without selecting or activating it. It is good practice to set the required workbook or sheet to an object. #VBA TO SELECT A RANGE ON A NEW WORKSHEET AND GO TO IT CODE#Run this code using the F5 key or manually to show the result. Code: Sub Macro2 () Range ('A1:A5').Select End Sub. If you want to select cells from A1 to A5, below is the way. We need to specify the range of cells to select in double quotes. We can also select required workbook when we have more than one Excel Workbook is opened. We can also select multiple cells at a time. When we have multiple worksheets in a workbook, we can select required sheet using VBA. VBA to Select Workbook or Worksheet in Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |