+ Reply to Thread
Results 1 to 2 of 2

VBA code to delete Drawing Objects from a specific Column.

  1. #1
    Registered User
    Join Date
    12-26-2016
    Location
    London, England
    MS-Off Ver
    365
    Posts
    79

    VBA code to delete Drawing Objects from a specific Column.

    Hi - I am trying to write some VBA code that deletes all Drawing Objects from all cells but only the active column?

    I have found code that deletes everything apart from those in the active column, but can't find the reverse.

    Example would be where the active cell is cell D7 - So need the code that deletes all drawing objects from Column D, and need to code to be of use in any column in the worksheet based on the active cell.

    Any ideas?

    Regards

    Hans

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: VBA code to delete Drawing Objects from a specific Column.

    Sorry Hans

    If you had posted your existing code, then we would have something to work with.


    Try this.

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 12-26-2016 at 08:42 AM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 09-20-2012, 11:54 AM
  2. Is it possbile to delete SELECTED drawing objects?
    By Borodin in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-06-2012, 06:46 AM
  3. Hyperlinks & Delete Drawing Objects
    By Zenarte in forum Excel General
    Replies: 2
    Last Post: 03-25-2010, 08:29 AM
  4. VBA Drawing Objects
    By moquenma in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-13-2008, 07:36 PM
  5. [SOLVED] Cut Drawing Objects within a range
    By CLR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2006, 01:35 PM
  6. [SOLVED] Cutting Drawing Objects
    By LostNFound in forum Excel General
    Replies: 3
    Last Post: 08-12-2005, 01:05 PM
  7. [SOLVED] HOW DO I KEEP DRAWING OBJECTS ANCHORED?
    By HOW DO I KEEP DRAWING OBJECTS ANCHORED? in forum Excel General
    Replies: 1
    Last Post: 05-20-2005, 09:06 AM
  8. Macro to Delete Drawing Objects
    By jimmeh in forum Excel General
    Replies: 0
    Last Post: 04-28-2005, 06:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1