You can get most things like this with the macro recorder.

With Worksheets("My Sheet").Range("B1:B3")
.Name = "TheRangeName"
.Font.Bold = True
.HorizontalAlignment = xlHAlignRight
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gwen" wrote in message
...
Please assist.

I want to programmatically name ranges.
for ex. b1, b2, b3
Then I want to bold and right align the named range.
Thanks