how often do you find the method .SELECT or .ACTIVATE in your code?
experienced VBA programmers would maybe find it 10 times in 1 large
module (maybe even 0).

If you find it 10 times in 1 procedure you could probably achieve
spectacular performance results by using object variables

I am new to VBA and in getting close to finishing my Project. I saw this
thread and was woundering about it.

I use SELECT or .ACTIVATE A lot and I dont really understand how to use an
Array I also dont quite know how I could do better with object variables.
Could you give an example.
Thanks