I am working on a rather complex Excel file that has various Database connections and VBA code behind it. This file is getting pretty old and has had many people work on it during its life.
There is one worksheet that much of the VBA code passes data into and out of. When I look at the sheet, it is completely white. I see the column titles at the top but no row names. It also doesn't seem to be protected or locked via the normal mechanisms.
I need to troubleshoot some data that I believe is within the sheet.
Does anyone know how this sheet might be hidden like it is and how I can view the data inside it?
What I've tried:
- I tried writing VBA code to select and copy 9999 rows from the blanked out sheet into a new sheet. The result is that I cannot scroll above row 10000 or view anything above row 1000, its as if row 10000 is the new row 1.
Thanks in advance!