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
"Bentam7" wrote in message
...
| 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?
|