Create a new article
Write your page title here:
We currently have 3,185 articles on s23. Type your article name above or create one of the articles listed here!


    Some usefull snips of Excel VBA that i use.

    work with multiple Worksheets[edit]

    this macro will Loop through all work sheets doing X... i found this on utteraccess this thread

    Public Sub UpdatetoNextWeek()
    Dim w As Excel.Worksheet
    If MsgBox("Update the week and period details?", vbYesNo + vbQuestion, "Confirm update") = vbYes Then
    For Each w In ActiveWorkbook.Worksheets
    w.Range("H9") = w.Range("H9") + 1
    w.Range("F9") = w.Range("F9") + 7
    Next w
    MsgBox "Done", vbOKOnly
    End If
    End Sub
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.