I keep on getting a run time error code 9. If you want to specify the workbook for the sh1 variable, do it in your set line: Web assuming sheet1 is the name of the sheet that you want to select. If we want to selects any single cell or collection of cells, then we use select worksheet method. To select the current worksheet, use the activesheet object: Web select worksheet by variable. You can use activate method of worksheet object to make a single cell as active cell. Web to select a sheet or multiple sheets, use the select method. Here is the example syntax to select worksheet using vba. If you want to select a worksheet instead of activating it you can use.select in the above codes instead of activate command.
Set sh1 = wb1.sheets (sheet1) and then you can check what workbook it's a part of by looking at it's.parent.name property: Web select range in a particular sheet in excel vba ask question asked 9 years, 11 months ago modified 1 year, 1 month ago viewed 81k times 6 i have a question about selecting a range in a particular sheet using excel vba. To use this example, your. More activate / select sheet examples. Web it either needs to be wb1.sheets (sheet1). Web select worksheet by variable. You can use activate method of worksheet object to make a single cell as active cell. Select worksheet by tab name. To make a single sheet the active sheet, use the activate method. If we want to selects any single cell or collection of cells, then we use select worksheet method. Selecting worksheets by code name can prevent errors caused by worksheet name changes.
