Own IWBasic 2.x ? -----> Get your free upgrade to 3.x now.........
Started by Brian, December 18, 2013, 02:33:05 PM
0 Members and 1 Guest are viewing this topic.
Quote from: Brian Pugh on December 18, 2013, 04:00:58 PMErr, Bill, what do you mean by C12?Brian
Quote from: Brian Pugh on December 20, 2013, 12:13:53 PMLarry,Re your example: You have an Excel file with 26 sheets, all with populated rows.You already know this. I have an Excel file that has 3 sheets, but there is onlydata in the first sheet. When you enumerate the sheets, the FOR NEXT loopends up on the last sheet nameHow can I code it so that it automatically selects Sheet1$ as the default sheet,or discards any sheet that is empty?Any ideas?Brian
QuoteBut trying it on anotherExcel file, which "appeared" to only have data in the first sheet, and "appeared" to have no data in the othertwo sheets, picked up the last sheet name, so there must have been something lurking in thereWonder if there is another way to see if there is actually "data" in an apparently empty sheet?