Forum Discussion

Copper Contributor

Jul 28, 2022

Adjust cell in multiple workbooks with VBA

Hi everyone I am trying to change cells range in one hundred workbooks using an excel list as a reference to the file location and the data I want to adjust in each workbook. File Name: File loc...

excel

Macros and VBA

HansVogelaar

MVP

Jul 28, 2022

Inawab770

Use

    With wkb
        With Sheets("JAN")
            .Unprotect
            .Range("F3:F5").Value = dt
            .Protect
        End With
        .Close SaveChanges:=True
    End With