For the b) question.

Asterisks?.........none that I know of.

For a thicker bule line, use the drawing toolbar to draw a rectangle over the
cell.

Format to transparent then set a blue line weight of your choice.

4 or 5 pts gives a thick line.


Gord Dibben MS Excel MVP

On Sat, 12 Jul 2008 13:36:02 -0700 (PDT), Lostguy wrote:


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