View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lostguy Lostguy is offline
external usenet poster
 
Posts: 15
Default a) char(10) and b) asterisks for borders?


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