![]() ![]() And as I explain below, it's usually best to use neither. The use case for each method depends on the scenario. This includes sheets, ranges, cells, shapes, charts, slicers, etc. ![]() Which Method Should I Use?įirst, it's important to note that both methods can be used on many different types of objects in Excel. Let's take a look at an example to see how this works. Activate can be used to active one object within the selection.Select can be used to select multiple objects (sheets, ranges, shapes, etc.) at the same time.The short answer is that Select and Activate can perform the same action, but the differences are: One question I hear often from new members of our VBA Pro Course is, “What's the difference between Select and Activate? It seems like they do the same thing?” Bottom line: Learn the difference between these two commonly used methods in VBA. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |