Results 1 to 2 of 2

macro to clear content

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    Singapore
    MS-Off Ver
    2002
    Posts
    71

    macro to clear content

    I have a macro to delete Sheets, but i also wan to clear the content in the Menu Sheet when this macro is run, For example I also wan to clear the content of range B20:D25.

    For i = Sheets.Count To 1 Step -1
                          If Sheets(i).Name = "Menu" Then
              Else
                          Sheets(i).Delete                         
              End If
    Next i
    Last edited by kaffal; 03-15-2009 at 12:08 AM.

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