Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello
Each week I copy a list of data from a web page and paste it into a Excel worksheet. The data, However, includes dozens of small graphi objects which I don't want so I have to delete them. I do this b EditGo ToSpecialObjects to select all objects on the sheet but have to deselect two objects before hitting delete. I tried recordin a macro for this but instead of showing a way to deselect the tw objects it listed all of the others. Is there a VBA equivalent to holding the shift key and clicking on th two objects to deselect them from the selection? The two objects fo deselection are named Picture 1 and Picture 2. Thanks for any help you might have -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide Selected Objects | Excel Worksheet Functions | |||
formula 2 display selected objects ONLY in new sheet from another | Excel Worksheet Functions | |||
How to deselect a selected chart programatically? | Charts and Charting in Excel | |||
how can I deselect one of the multiple selected rows? | Excel Discussion (Misc queries) | |||
Deselect one of many non-adjacent rows selected | Excel Discussion (Misc queries) |