Just a tip I have picked-up
Russell Lucas wrote:
Hi everyone,
I have looked at a lot of code in this forum, and I have seen a lot of ActiveCell and ActiveSheet begin used. This is somthing I was doing myself up in till a couple of days ago when a coleague recommended using absolute references. I tested this and found that it not only made the code more robust, it also improved speed four fold.
I can't morally keep that to myself so I thought I would share that with anyone who does not already know.
Canyou give an example on replacing ActiveCell or ActiveSheet with
absolute references??
Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.
|