| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove multiple objects
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove multiple objects
try
Sub ShapesCut() For Each s In ActiveSheet.Shapes s.Cut Next End Sub -- Don Guillett SalesAid Software "widman" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove multiple objects
Sub DeleteObjects()
ActiveSheet.DrawingObjects.Select Selection.Cut End Sub Vaya con Dios, Chuck, CABGx3 "widman" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I remove multiple 'errors' in Excel error checking, at the same time??? | Excel Discussion (Misc queries) | |||
| how to remove multiple @ signs from email? | New Users to Excel | |||
| How do I remove multiple windows of 1 workbook (filename.xls:2,:3 | Excel Discussion (Misc queries) | |||
| How can you remove all objects in a worksheet at once? | Excel Discussion (Misc queries) | |||
| how to delete multiple autoshape or objects in excel | Excel Discussion (Misc queries) | |||
Linear Mode
