vba - section of indices of empty cells in a row : In a *first step*, I am trying to identify the **indices** of the **empty cells** in a **row** in an excel workbook. In a *second step*, I want to use these indices to delete certain **columns** in **another** excel workbook. How can one do so?

Here I found some related info http://stackoverflow.com/questions/7876340/deleting-empty-rows-in-excel-using-vba

Why I want to do this:

I am importing worksheets from closed excel workbooks into an open workbook. When doing so, I only import the data and not the column names (because these are messy and not appropriate for importing later on in R: defined by three rows and some of these cells their rows are merged).

The problem is that there are empty columns inserted between parts of the data in the closed excel workbooks. I cannot simply delete the columns with no values afterwards, because it can well be that there are columns with no values but that had a column label in the original workbook.