![]() ![]() To activate the sheet, we need to mention the exact worksheet name by using worksheets object. Source: VBA Activate Sheet () What is VBA Activate Method?Īs the name says, it activates the specified worksheet. ![]() You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked However, in VBA, it is not that easy we need to specify the sheet name we are referring to, then we can use the “Select” method to select the sheet. read more, or we directly select the sheet by clicking on them. In regular spreadsheet workings, we directly navigate thorough shortcut keys Shortcut Keys An Excel shortcut is a technique of performing a manual task in a quicker way. Worksheets have their own name to identify better. In excel, we always work with worksheets. While working in VBA we sometimes refer to another sheet or use another sheet’s properties, suppose we are in sheet 1 working but we want a value from cell A2 in sheet 2, if we refer to sheet 2’s value without activating the sheet first then we will not be able to access the value so to activate a sheet in VBA we use worksheet property as Worksheets(“Sheet2”).Activate.
0 Comments
Leave a Reply. |