Extracting deleted records

Mar 2, 2013 at 8:17 PM
I have a case where I'm extracting data from an Excel 2010 spreadsheet and I'm getting records that used to be in the spreadsheet but were "supposedly" deleted. Can't see them when I look at and search the spreadsheet and if I copy that tab into a new sheet and extract from that they aren't there.

I do have a sheet I can send.
Mar 4, 2013 at 7:31 AM
Please send, plus any code for showing the error.

I didn't know Excel did that, will be interesting to look at.
Mar 4, 2013 at 3:39 PM
Edited Mar 5, 2013 at 3:13 PM
Can I email the file directly to this address? I need to make sure this file is treated as confidential.
Mar 4, 2013 at 3:40 PM
Edited Mar 4, 2013 at 3:48 PM
...
Mar 4, 2013 at 3:46 PM
Edited Mar 5, 2013 at 3:13 PM
I have a work around. The problem child is the Inventory_Rental tab and, I don’t believe, anything above line 2140 shows up in the spreadsheet. This is what I see at line 2140: That’s a new header in 2141>
Mar 5, 2013 at 11:40 PM
Found it. Programmer headspace. I wasn't clearing my write buffer between tabs.

Thanks for the help. This is GREAT code.