So I am trying to filter a spreadsheet to non-blanks, create a new workbook and then paste the non blank filtered rows into that other workbook.
I am getting an error 438 "Object does not support this property or method" on the bold line below.
Any ideas what is causing this? Thank you so...