Need Help in VBA for my scenario in Excel

[sanmaya]

Hi all,


i have sheet in which the 68th column having title type and column 69 to 72 are columns which contains vlookup formula in their cell. the sheet have 50000 rows. the type column have three values in it "YES" , "NO" and blank cells. i want to remove the rows in which the type column cell is blank. can any body suggest me a macro for that which will run faster and would not temper the vlookup formulas.


it will be a great help .


thanks

 

[sreekhosh]

Hi Sanmaya,


Just go through the below links. It will help you too


http://www.excelbanter.com/showthread.php?t=245382


http://www.excelforum.com/excel-general/573637-delete-rows-where-that-contain-an-empty-cell.html


Thanks


Sreekhosh