I'm having trouble deleting rows in Excel 2007 using filters. I have a large
volume of data from another program which I import in Excel and a simple
macro went through and deleted all the garbage lines. I encountered a
problem moving from Excel 2003 to 2007 as when highlighting all the rows it
deleted all of them not just the visible rows. I started to overcome this
using the Show visible cells option, but I'm now getting the message
"Microsoft Office Excel cannot create or use the data range reference because
it is too complex".
I would happily go back to Excel 2003, but I have a lot more than 65,000
rows of data.
Any other suggestions?