Macro for Deleting the entire row if first two columns are blank

[Nithya1987]

Hi ,

I am trying to write a macro which will delete the entire row if first two columns data is null. I have the below code but I am not sure how to get the workbook name as variable for WksName in the below code, I can't hard code the value as the worksheet names are dynamic and I have to run this code on regular basis for all the files in c:\test folder.

Please suggest.

Please Login or Register  to view this content.

Thank you.

[Domski]

So the worksheet that you want to work on in each file that you open has the same name as the workbook containing the code?

Dom

[Steffen Thomsen]

Is the sheet allways in the same position eg. first sheet in workbook

then use the line

Please Login or Register  to view this content.

The you can make the check like this

Please Login or Register  to view this content.

Steffen Thomsen

[Domski]

You will run into problems looping through a range like that and deleting rows. If you want to loop you must do it backwards or you will get odd results, another option is to use autofilter.

Dom