+ Reply to Thread
Results 1 to 5 of 5

Can't create macro for deleting objects

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Santa Rosa, CA, USA
    MS-Off Ver
    Excel 2010
    Posts
    44

    Can't create macro for deleting objects

    I am trying to use a macro to delete objects on a worksheet imported from a website. The "find/select, go to special, objects, OK" all work fine with a macro. But to delete the objects, one needs to hit "backspace" (I think... that's the keystroke I use to manually delete them) and the macro freezes and won't delete. Any ideas? Do I need to just create a macro to do the first steps and hit "backspace" after the macro finishes?

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Can't create macro for deleting objects

    Where is the example file. And/or your code?

  3. #3
    Registered User
    Join Date
    10-02-2013
    Location
    Santa Rosa, CA, USA
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Can't create macro for deleting objects

    Not sure the file will attach...
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    Re: Can't create macro for deleting objects

    Please Login or Register  to view this content.
    Does this simple macro works?
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    10-02-2013
    Location
    Santa Rosa, CA, USA
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Can't create macro for deleting objects

    Worked beautifully and was simple. Thanks

+ 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. [SOLVED] Macro Is Deleting all Pictures and ActiveX Objects
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 01:26 PM
  2. Issue with deleting objects
    By sbernard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2011, 12:03 PM
  3. Deleting objects using Macro
    By dreicer_Jarr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2008, 02:55 PM
  4. Deleting objects within a certain range
    By JohnnyBGood in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2007, 10:11 PM
  5. Deleting and resizing the calendar objects
    By Bobmckelvy in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 09-16-2006, 08:31 PM
  6. [SOLVED] Deleting Objects Copied from Web Page
    By Tim Childs in forum Excel General
    Replies: 3
    Last Post: 02-21-2006, 06:55 PM
  7. deleting objects
    By Larry Sartoris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2005, 01:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1