Delete the Blank lines

Hi,

I have a dump of xls files in a folder, all these files have blank lines in them , can you give me some idea on how to write a macro which will delete the blank lines from all the files in a particular folder.

Thx,Bds

I'm not sure how to delete blanks from all files within a folder... but a quick work-around option might be to place a simple macro in the "Workbook_Open" function of each individual sheet...

Please Login or Register  to view this content.

reachbds,

Give the following a try. It will prompt you to select a folder, and then remove blank rows from each worksheet in each .xls file in that folder.

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar