+ Reply to Thread
Results 1 to 11 of 11

Deleting sheets

  1. 07-09-2008, 07:47 PM #1
    christo
    christo is offline
    Registered User
    Join Date
    06-27-2008
    Location
    brisbane
    Posts
    23

    Deleting sheets

    I need some help with a code that checks if there is a sheet name and if there is a sheet of that name then it is deleted.

    the sheet name is a number entered through an inputbox and "Average"
    Please Login or Register  to view this content.
    Last edited by christo; 07-09-2008 at 08:26 PM.
    Reply With QuoteRegister To Reply
  2. 07-09-2008, 08:11 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Please read the Forum Rules and then wrap your code with Code Tags.
    Reply With QuoteRegister To Reply
  3. 07-09-2008, 08:18 PM #3
    lxblxb
    lxblxb is offline
    Registered User
    Join Date
    07-09-2008
    Location
    NY
    Posts
    2

    VBA program to compare two sheets,delete blanks,advanced search, multiple goal seek

    try this simple one: if (thisworkbook.sheets(index).name = "name" then thisworkbook.sheets(index).delete

    I made some VBA programs to compare two sheets, delete blanks in rows and columns, read huge txt file and csv file into excel, advanced search and replace (search cell value larger or less than a value, and search string), and multiple goal seek. if you are interested in it, contact me xgncjx@yahoo.com
    Reply With QuoteRegister To Reply
  4. 07-09-2008, 08:28 PM #4
    christo
    christo is offline
    Registered User
    Join Date
    06-27-2008
    Location
    brisbane
    Posts
    23
    Thanks shg
    I forgot to add the code tags
    Reply With QuoteRegister To Reply
  5. 07-09-2008, 08:28 PM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Thank you.

    I'm confused by Average and Cumulative; are there two sheets to delete or one?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 07-09-2008, 08:36 PM #6
    christo
    christo is offline
    Registered User
    Join Date
    06-27-2008
    Location
    brisbane
    Posts
    23

    correct code

    There is only one sheet of a graph there was an error in the code I posted

    it should have been
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 07-09-2008, 08:40 PM #7
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    You don't show where plantnumber is set, but that's essentially how mine works -- try it and post back.
    Reply With QuoteRegister To Reply
  8. 07-09-2008, 09:03 PM #8
    christo
    christo is offline
    Registered User
    Join Date
    06-27-2008
    Location
    brisbane
    Posts
    23

    Code didn't work

    I tried your code and it returned 

    Please Login or Register  to view this content.
    the code returned error 9 "subscript out of range"
    when it got to this line in the code 
    Please Login or Register  to view this content.
    the plant number was PW701 and the sheet name was PW701Average

    there was a worksheet with this name

    Will this code work without the end sub as I need the code in the middle of a sub
    Last edited by christo; 07-09-2008 at 09:08 PM.
    Reply With QuoteRegister To Reply
  9. 07-09-2008, 09:06 PM #9
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    worksheet or chart sheet?

    If it was a chartsheet, change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 07-09-2008, 10:36 PM #10
    christo
    christo is offline
    Registered User
    Join Date
    06-27-2008
    Location
    brisbane
    Posts
    23

    Thank you that worked

    That worked thank you for your help
    Reply With QuoteRegister To Reply
  11. 07-09-2008, 11:17 PM #11
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Great, you're welcome.
    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)

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