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.