You are visitor number since 30 December 2002.
Go to Howard Kaikow's home page

From time to time, I encounter bugs or "features" in Excel. In order to share that knowledge, I may, from time to time, post information at my web site. At this time, I am making available the following:

1. Areas collection returns wrong worksheet (Excel) (Revised: 12 February 2003)

1. Areas collection returns wrong worksheet (Excel)

   Under certain conditions (using Excel 97, Excel 2000, and Excel 2002), the Areas collection returns values from the wrong worksheet. The example I provide demonstrates how to replicate the problem.