Delete Table Rows of filtered data - when some columns are hidden

Just trying to delete the red rows here... some columns are hidden though which I think is what is giving me the problem - due to the visible cells reference...

Id guess I just have to say visible cells, rows, but ive been trying for a while and am just not getting it haha...... what am I doing wrong here - see attached

Thank you for any help!


Here are 2 of the recent ones ive tried.. although theres been like 6-7 variations..

Please Login or Register  to view this content.

So this is halfway there... 2 problems with it though --- 1, the blank rows 1-4 are being removed and 2, its throwing an error..... i put an on error resume in there just to see if it works..

can anyone fill in the blanks here maybe?

Please Login or Register  to view this content.

Got ittt... thanks to everyone for the help! haha

Please Login or Register  to view this content.