Deleting rows in Excel 2007 using filters

[Bentam7]

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?

 

[Jim Rech]

Do you think you could post a simple set off step by step instructions on
how to recreate this problem? Assume that none of us has access to the data
you're using, etc.

--
Jim
| 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?
|