Hi there, I often get #VALUE error cells in my data set - these could appear on any row and what I would like is some quick coding to filter (by column B) any error cells and delete the rows.

As I have said, the rows could appear on any number so its not possible to fix these rows I need a dynamic macro