how to delete rows in a table in excel

[mahi4tech]

Hi All,

I have a requirement to delete a row in a table if few of the columns in the table doesn't contain data using a macro or VB code

can anyone help me on this please.

Thank you,
mahi

[Martijnvc]

Million solutions, better post a workbook explaining your case in more detail

[curiosity1990]

Hey mahi4tech..

why don't you post some sample code. It will be easier to help you with the solution!

[mahi4tech]

Hi ,

I have attached a sample excel with a table named "Table2" with 7 columns

my requirement is i need to delete a row in my table if say column 1,2 and 4 doesnt have any data in their respective cells
req.png

[Martijnvc]

Find attached, should get you started. Not the neatest approach, perhaps somebody has cleaner coded method?

Code:

Please Login or Register  to view this content.