PDA

View Full Version : Solved: Declare 2 Named Ranges for Cell Properties



khalid79m
11-28-2008, 03:26 AM
With Range(Array("File_Name", "Site"))
.Locked = True
.NumberFormat = "@"
End With

what am i doing wrong ~???:dunno

Bob Phillips
11-28-2008, 03:47 AM
With Union(Range("File_Name"), Range("Site"))
.Locked = True
.NumberFormat = "@"
End With

khalid79m
11-28-2008, 03:54 AM
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:bug:

khalid79m
11-28-2008, 05:14 AM
for the advice, really appreciated it.