By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,646 Members | 2,098 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,646 IT Pros & Developers. It's quick & easy.

Need Help on How to check if the excel table is empty

P: 17
I have a program that combines the contents of other tables into one tables.
If it sees any bad data from each table, it stores it into the tables called errors:
So the inputs like this:
table1,table2,table3

the output:
combinedTable, errorTable1,errorTable2,errorTable3. The bad data from table1 will go to errortable1, etc.

My question is How to check to see if some of the error table is empty?

Any idea or suggestion is appreciated.

Thanks.
Dec 12 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 5K+
P: 8,434
Well, you could just check a position that you know will be populated if anything is placed in that table. For example, if "$A$1" is blank then nothing has been filled in.
Dec 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.