I found a hidden column that had a ref in it
So now the code runs without a mismatch but it is still hiding rows that have values in them. It should only hide the row if all cells in that row are zero.. ie. no values in that row.
See attachment for example of layout.