+ Reply to Thread
Results 1 to 2 of 2

Sheet Delete not found

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Groenlo, Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    64

    Sheet Delete not found

    I am using a code to delete a specific sheet. I get an error message that the sheet can't be found. The sheet does exist, is not the last sheet left, and only one Excel file is open. What am I doing wrong?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,988

    Re: Sheet Delete not found

    Try and stay away from On error statements...rather test...
    If this bypasses then the sheet does not exist...check leading or trailing spaces in sheet name...
    Please Login or Register  to view this content.
    I get an error message
    Your code...As is should not show an error as you are bypassing this...Not sure if there is more to your code though...
    Last edited by Sintek; 10-11-2024 at 03:16 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

+ 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] search code in other sheet and if found delete full row
    By kv.singh in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-12-2022, 12:08 PM
  2. [SOLVED] message box indicating "no result found" when a cell value is not found in a sheet
    By Lona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2021, 11:12 AM
  3. Replies: 0
    Last Post: 05-05-2021, 10:08 AM
  4. [SOLVED] Compare columns on one sheet to another and delete if negative values found
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-04-2019, 10:39 PM
  5. Found?, then delete entire rows. Not found end sub
    By Andrewstupendo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2018, 01:56 PM
  6. Delete rows in Sheet A if any conditions found in Sheet B met
    By Anselmcai in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-03-2014, 09:54 PM
  7. Replies: 3
    Last Post: 03-04-2014, 04:55 AM

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