Excel is also giving me the error message that auto-recover has been
disabled. I think something is wrong with this module in my personal
workbook and I surely need to know how to fix it.

"Janis" wrote:

I did declare it elsewhere. Why does it affect another macro? It isn't a
global variable meaning I didn't define it in the declarations.
thanks,

"stevebriz" wrote:

do a Search for all the project and see if you have declared Rng
elsewhere that could affect it?