LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Cut Drawing Objects within a range

Hi All...........
Is it possible to select a named range, and then cut or delete all Drawing
Objects located within that range?

I do not know the name of the Drawing Object, as Excel assigns a new name
when I copy and pastespecial the Drawing Object each time. An alternative
would be if I could delete the "last drawing Object created", whatever it's
name/number might be.....or if somehow I could give the pastespecialed
drawing Object a new name of my own, and then later could delete it by name.

TIA for any assistance,
Vaya con Dios,
Chuck, CABGx3




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drawing objects in Excel 2007 cf1uk Excel Discussion (Misc queries) 1 November 4th 09 02:41 PM
Group drawing objects in VBA Bubb Excel Discussion (Misc queries) 2 April 10th 06 04:22 PM
Cutting Drawing Objects LostNFound Excel Discussion (Misc queries) 3 August 12th 05 05:35 PM
HOW DO I KEEP DRAWING OBJECTS ANCHORED? HOW DO I KEEP DRAWING OBJECTS ANCHORED? Excel Discussion (Misc queries) 1 May 20th 05 01:35 PM
[Q] parameters to drawing objects Rolf Marvin Bøe Lindgren Excel Programming 1 May 12th 04 10:20 AM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"