+ Reply to Thread
Results 1 to 6 of 6

CHECK if picture with a specific name exists and, if so, delete it

  1. 08-12-2016, 04:26 PM #1
    Josiah
    Josiah is offline
    Forum Contributor
    Join Date
    01-06-2004
    Posts
    121

    CHECK if picture with a specific name exists and, if so, delete it

    How do I use VBA to check a sheet to see if a picture named "PICTURE" is present?
    Reply With QuoteRegister To Reply
  2. 08-12-2016, 04:30 PM #2
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: CHECK if picture with a specific name exists and, if so, delete it



    Check Name property of each element of Shapes collection …
    Reply With QuoteRegister To Reply
  3. 08-12-2016, 04:35 PM #3
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: CHECK if picture with a specific name exists and, if so, delete it 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-12-2016, 05:16 PM #4
    sanram
    sanram is offline
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: CHECK if picture with a specific name exists and, if so, delete it

    Use this :
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 08-12-2016, 06:11 PM #5
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: CHECK if picture with a specific name exists and, if so, delete it

    Try something like this. It deletes a shape object named "Picture" and ignores the error if it doesn't exist.
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  6. 08-15-2016, 08:27 AM #6
    Josiah
    Josiah is offline
    Forum Contributor
    Join Date
    01-06-2004
    Posts
    121

    Re: CHECK if picture with a specific name exists and, if so, delete it

    Thanks everyone!

    AlphaFrog - Perfect!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to delete picture object in specific area only vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-14-2013, 04:01 AM
  2. [SOLVED] Macro - Delete specific worksheet IF it exists
    By aetedford in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2013, 03:24 PM
  3. [SOLVED] Check if sheet exists and delete it using IF ERROR function in VBA
    By Jardim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2012, 12:06 PM
  4. Macro to filter data and delete a row if a specific value exists
    By coxb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2012, 10:09 PM
  5. Check if Specific Visible Worksheet Exists
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-24-2011, 11:35 AM
  6. HOW TO: Check if a picture exists?
    By Kevin McCartney in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2006, 11:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1