Can't delete entire row based on condition in table range.

Hi everybody,

I am facing issue with simple macro code which should delete entire row based on condition in specific column. I am using this code in other sheets and it works with no problems, but in this file is used Table, instead of normal range of cells.

Table is between columns "B" and "BD". I am want to delete entire row based on condition "SGP" in column BF. I hoped that put one blank column between the end of table and condition's column would help, but unfortunately no. Could you pls help me update this code to catch my criteria?

Please Login or Register  to view this content.

xladept - thanks for your response. I already tried to record it before, but doesn't work in code after such update. Probably I used it wrong.

And I also don't know, how can I update my code by using your code. Could you be so kind and help me to apply your bit of code into my? Thanks in advance for your help, understanding and patience.

Refer to enclosed example file. What I need is to delete entire row if column BF = SGP.

Just fyi, I used column "BF" to define my criteria and avoid Table range, but if could help, it can be used in previous column "BE"

Thanks so much!