+ Reply to Thread
Results 1 to 25 of 25

Message Boxes in Reset Macro

Hybrid View

  1. #1
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Message Boxes in Reset Macro

    I can see the finish line from here ...

    Sub ResetWorkbook2()
    ' ResetWorkbook Macro
    ' This macro will reset your workbook
        Application.ScreenUpdating = False
        Range("A8").FormulaR1C1 = "Rate Indication"
        Application.EnableEvents = False
        With Sheets("Loss Development Factors")
            .Range("B3:U22").ClearContents
            .Range("B52").FormulaR1C1 = "=MEDIAN(R[-7]C:R[-2]C)"
            .Range("B52").AutoFill Destination:=.Range("B52:T52"), Type:=xlFillDefault
            .Select
            .Range("B3").Select
        End With
        With Sheets("Claim Count - Credibility")
            .Range("B3:U22").ClearContents
            .Select
            .Range("B3").Select
        End With
        With Sheets("Rate Indication Instructions")
            .Range("N28:O53").ClearContents
            .Range("Q37").ClearContents
            .Range("I20").ClearContents
            .Range("I15").ClearContents
            .Range("I14").ClearContents
            .Range("I13").ClearContents
            .Range("I11").ClearContents
            .Range("I10").ClearContents
            .Range("I9").ClearContents
            .Range("I8").ClearContents
            .Select
            .Range("C56").Select
            .Range("I8").Select
            .Range("C37:C56").Cells.ClearContents
        End With
        With Sheets("Summary & Results")
            .Range("P32").FormulaR1C1 = "=R[-4]C"
        'ActiveCell.FormulaR1C1 = "=R[-4]C"
        End With
        Application.EnableEvents=True
        With Sheets("Selection")
            .Range("A8").FormulaR1C1 = "Loss Ratio Projection"
        End With
        Application.EnableEvents=False
        With Sheets("Loss Ratio Proj Instructions")
            .Range("P22:Q47").ClearContents
            .Range("S31").ClearContents
            .Range("I14").ClearContents
            .Range("I13").ClearContents
            .Range("I11").ClearContents
            .Range("I10").ClearContents
            .Range("I9").ClearContents
            .Range("I8").ClearContents
            .Select
            .Range("C52").Select
            .Range("I8").Select
            .Range("C33:C52").ClearContents
        End With
        Application.EnableEvents = True
        With Sheets("Selection")
            .Range("A8").FormulaR1C1 = ""
            .Range("A8").Select
        End With
        Application.ScreenUpdating = True
    End Sub

  2. #2
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    Re: Message Boxes in Reset Macro

    Quote Originally Posted by Andrew-R View Post
    I can see the finish line from here ...
    Haha, Unfortunatly i am now getting those stubborn boxes popping up again. hah, this is so frustrating. It seems to be back at square one.

+ 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