0 votes
in VBA by Beginner (10 points)
Hi everyone, what is the difference between using Activate and Select? Thanks!

1 Answer

+1 vote
by Expert (911 points)
selected by
Best answer

"The short answer is that Select and Activate can perform the same action, but the differences are: Select can be used to select multiple objects (sheets, ranges, shapes, etc.) at the same time. Activate can be used to active one object within the selection." 
See this link.

by Beginner (10 points)
Thanks JWoolley. Perfect answer!

Welcome to wellsr Q&A
Ask any questions you have about VBA and Python and our community will help answer them. wellsr Q&A is the standalone question and answer platform for wellsr.com. If you have a question about one of our specific tutorials, please include a link back to the tutorial.

Getting Started
VBA Cheat Sheets (On Sale Now)

Looking for something else? Hire our team directly through ourVBA Help page, instead.

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.