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:
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.