Help with programmingBorders
 

How can I place Borders around indivedule cells in a range?

Help with programmingBorders
 

Example:

Range("your range").Borders.LineStyle = xlContinuous
--
Regards,


"Al" wrote:

How can I place Borders around indivedule cells in a range?

Help with programmingBorders
 

Thank you very much liz, it worked. I am also trying to lock the same range
for editing. I used allowedits = false but it did not work. could you help?
thanks
Al

"Liz" wrote:

Example:

Range("your range").Borders.LineStyle = xlContinuous
--
Regards,


"Al" wrote:

How can I place Borders around indivedule cells in a range?

Help with programmingBorders
 

Range("Your Range").Locked = True
--
Regards,


"Al" wrote:

Thank you very much liz, it worked. I am also trying to lock the same range
for editing. I used allowedits = false but it did not work. could you help?
thanks
Al

"Liz" wrote:

Example:

Range("your range").Borders.LineStyle = xlContinuous
--
Regards,


"Al" wrote:

How can I place Borders around indivedule cells in a range?