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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.