Posts by Vnaza112

    royUK, Thank you so much for taking the time to help me. I just do not get it. I tried it, but it is not working.


    I will not take up any more of your time, but I really want thank you for what you have given me to this point. It means a lot.


    Happy Holidays and I wish you a Safe and Healthy New Years!

    :)

    Thank you for your quick response.


    This is what I did and I get an error in the highlighted and underlined in red spot below


    Good afternoon to all:


    I was given the following VBA to make changes to a specific cell range. The VBA works great, but it does the change to all of my worksheet. I was ten given information on how to make the VBA good for only a group of Worksheets, But I do not know how to put it together. I do not know VBA. Some one please help...


    1) Below is VBA that makes changes to all worksheets:





    2) AND this is the suggestion I got to make changes only in a group of worksheet:


    Code
    Dim WorksheetName As Variant
    
    
    For Each WorksheetName In Array("Sheet4", "Sheet6", "Sheet8")
    If WorksheetName <> cws.Name Then
    ThisWorkbook.Worksheets(WorksheetName).Range(addr) = chg
    End If
    Next WorksheetName



    3) Can Someone please help me put it together?

    Thank you so much