Solved: Declare 2 Named Ranges for Cell Properties

[khalid79m]

    With Range(Array("File_Name", "Site"))
        .Locked = True
        .NumberFormat = "@"
    End With

what am i doing wrong ~???

[Bob Phillips]

[vba]

With Union(Range("File_Name"), Range("Site"))
.Locked = True
.NumberFormat = "@"
End With
[/vba]

[khalid79m]

Set UnionRange = Union(Range("File_Name"), Range("Site"))
With UnionRange
    .Locked = True
    .NumberFormat = "@"
End With

this is what i managed to write following the help guides , i guess i was nearly there.. go to get better at this

[khalid79m]

for the advice, really appreciated it.