+ Reply to Thread
Results 1 to 3 of 3

Issue with deleting objects

  1. #1
    Registered User
    Join Date
    09-24-2010
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2007
    Posts
    21

    Issue with deleting objects

    The attached file was working properly. I added Sub SaveDate and now Sub Delete_Button bombs out and I receive the following error message "Run-time error '-2147024809 (80070057)': The specified value is out of range.

    I added On Error Resume Next to Sub Delete_Button so I don't receive the error message, but that doesn't solve the issue (only avoids it).

    Sub SaveDate and Sub Delete_Button aren't tied together, so I'm not sure why I am receiving the error message. Any help would be appreciated.
    Attached Files Attached Files
    Last edited by sbernard; 07-26-2011 at 12:06 PM.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: Issue with deleting objects

    I don't know for sure but I think you need to unprotect the sheet before you can delete the objects.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    09-24-2010
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Issue with deleting objects

    Thanks! Stupid mistake on my part.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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