L
Legacy 215653
Guest
I am opening a csv file using an excel 2003 object in VB6.
I am currently looing through the rows in the sheet and bypassing all the rows which do not have any data in columns A to D (other data may or may not be in other columns).
What I want to do is select and delete all rows which do not contain any information in colunms A to D BEFORE looping through the spreadsheet object to process the remaining rows which DO have data in columns A to D.
Is there a quick way to select and delete these rows? This select/delete has to be performed in VBA/VB6 code as this is an automated process.
I am currently looing through the rows in the sheet and bypassing all the rows which do not have any data in columns A to D (other data may or may not be in other columns).
What I want to do is select and delete all rows which do not contain any information in colunms A to D BEFORE looping through the spreadsheet object to process the remaining rows which DO have data in columns A to D.
Is there a quick way to select and delete these rows? This select/delete has to be performed in VBA/VB6 code as this is an automated process.