By the way, VB has a pre-defined constant for Chr(10) which is vbLf (where
Lf stands for Line Feed, which is what you are calling HRT). So, you could
do these also...

vbLf & vbLf & vbLf

or

String(3, vbLf)

as well as what I posted earlier.

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
You should be able to use this...

String(3,10)

where the first argument is how many you want and the second argument is
the ASCII and/or ANSI value; or the second argument could be the character
itself, that is, this would work too...

String(3, Chr(10))

Rick


"Lostguy" wrote in message
...

Hello.

a) For three HRT's, you can use char(10)&char(10)&char(10).
Is there a way to shortcut this to char(10)*3, or similar?

b) Also, in Excel 2003, is there a way to put a border of asterisks
around a cell without using VBA? Is there a way to make a thick blue
border around a cell?

(On the Format CellsBorder, I can't see a way to increase the
thickness of the borders beyond the few options the presets give
you..)

??

All help appreciated!

VR/

Lost