Yes, I totally agree. It would appear that I may (probably) did have a
variable "addRess" at some time in the past. however it *No* longer
exists in this workbook, however, where ever I try to use the
"Address" keyword, the workbook converts it to "addRess" .... It's
now driving me up the wall!

Once you have that variable, Excel has a very good memory. The only way to
fix this is to declare a variable

Public Address As Variant

Compile, Save. Then delete the Dim line. That will reset whatever memory
VBA had of your different capitalization. I don't know if the Compile and
Save parts are really necessary, but I always do them.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com