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



    s23
    3,187Articles

    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.
    Cookies help us deliver our services. By using our services, you agree to our use of cookies.