VBA challenge

[excelros]

How do i delete an entire row if 1 column cell in that row is N/A?

There are like 30000 rows in entirety.

I will appreciate any VBA code and how to get this done? Please advise

Thanks!

[TMS]

You don't really need VBA. You could just Autofilter on the column for N/A, select the visible rows and delete them.


Regards, TMS

[excelros]

Thanks a lot, dude - I never thought of it. I guess this should work.

Best!

[TMS]

You're welcome.

For future reference, have a look at the forum rules. You need to use thread titles that describe your problem; I guess that "VBA Challenge" does not comply.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[excelros]

Sure dude! Thanks. I shall.