Guys,
I have a weird problem. I have to generate a table with random number of columns. Out of those randomly generated columns (Column names are random as well..i mean they can vary depending on the request), some are blank with no data in them.
I need to write a code in vba (actually a module) to sequentially browse through different columns in the table and check whether the columns are empty or not. If they are empty, delete the columns from the table...or if its easy, create another table with only the columns that have data in it (not blank columns....can have a single record also)..
Please help...
P.S. I am not a coding guy so any simplification or a ready made code would be greatly appreciated..
Thanks
Kapil0712