I'm trying to filter a table and then delete only the visible rows in an excel table a snippet of my code below prompts the error
"Delete method of range classs failed"
sheet name: wksRawDataLastWeek
table name: tblRawDataLastWeek
can you assist?