Why should Select and Activate be avoided in VBA?
- A They are slow and make code fragile; working with object references directly is better
- B They are deprecated syntax
- C They cannot be used in loops
- D They require administrator rights
Answer
They are slow and make code fragile; working with object references directly is better
Recorded macros are full of Select because the recorder captures user actions, which is why recorded code needs rewriting.





