There is very little difference between activating a worksheet and selecting a worksheet. The following means that worksheets 'Sheet 1', 'Sheet 2' and 'Sheet 3' . Calling the Activate method of a Worksheet object makes that sheet the active sheet, meaning it visually is on top and all macro actions that use ranges without . May 9, 2015 - Activate a new sheet, that you did not need to use With. . It's a minor point, but it can cause little logic errors in code that are difficult to track . This article will discuss the ActiveSheet object in VBA. It will also discuss how to activate, select, and go to Worksheets (& much more). Oct 10, 2005 - Activate >>It will activate Sheet2 ( all other sheets are still selected) Just one little refinement, Ron. The above is true only if there are more Hi, I have a sheet where I instruct users to select Enable Content before . it easier for others for find the right solution, plus a little gratitude goes a long way! the workbook save with the correct sheet activated before closing, . Aug 8, 2011 - For example, you can jump in between workbooks without activating . it does no harm to activate -- except for a small hit to performance which . Dec 3, 2018 - Google Sheets Macros are small programs you create without needing any code. You record your actions so you can repeat them and save . Feb 21, 2013 - Referencing Ranges in Other Sheets. Switching between sheets by activating the needed sheet can dramatically slow down your code. Unfortunately , many people design their Excel spreadsheets with little . If it isn't, it will ungroup the sheets simply by activating the sheet you are already on.