Results 1 to 11 of 11

Deleting sheets

Threaded View

  1. #1
    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"
    Dim w as range
        For Each w In Worksheets
        Worksheets(plantnumber & "Average").Select
        If w.Name = plantnumber & "Cumulative" Then
        w.Select
        Selection.Delete
        End If
        Next
    Last edited by christo; 07-09-2008 at 08:26 PM.

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