View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default remove multiple objects

F5SpecialObjectsOK

EditClearAll


Gord Dibben MS Excel MVP

On Tue, 26 Dec 2006 08:00:01 -0800, widman
wrote:

I get reports exported to Excel from a program written with Access, but they
come over with dozens of lines where the pages were formated to look pretty.
I can click on the lines and cut, but have to do it over and over.
How can I remove ALL objects on a page, leaving only the text and numbers?