| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Imported objects
Hi
When a file is imported into Excel from another package it imports a lot of "invisible" objects that make the file very large. There are quite a lot of changes to be made to the file anyway which I am sorting out in VBA, but I don't know a way of quickly selecting and deleting all the objects in a file other than the manual way. Does anyone know how this can be done? Many thanks. |
|
#2
|
|||
|
|||
|
Hi
F5 Special Object Ok Press the delete key now -- Regards Ron de Bruin http://www.rondebruin.nl "aehan" wrote in message ... Hi When a file is imported into Excel from another package it imports a lot of "invisible" objects that make the file very large. There are quite a lot of changes to be made to the file anyway which I am sorting out in VBA, but I don't know a way of quickly selecting and deleting all the objects in a file other than the manual way. Does anyone know how this can be done? Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I put drawing objects behind text/cells in a spreadsheet? | Excel Discussion (Misc queries) | |||
| Literally displaying imported cells with and tags | Excel Discussion (Misc queries) | |||
| Help - Cannot shift objects off sheet problem | Excel Discussion (Misc queries) | |||
| Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Linear Mode
