program to remove a row in excel baseed on cell value
Can some one tell me how achieve the following task?
I have a excel and i want delete some rows based on the particular cell
value, but the excel is very very huge it has got around 75000 rows. I
tried writing a nomal function to loop through the sheet, check for the
cell value and delete the rows if matched. but it is taking very long
time. i waited for 30 min and program was still running can some one
suggest me how to achieve this.
Thanks in Advance. Veeresh
No comments:
Post a Comment