Chip,

Not quite.

If you select 9 cells, say a 3x3, then Borders(XlLeft) will not only
border the leftmost 3 cells, but also the other 2 columns of cells, too.

Borders(xlEdgeLeft) will ONLY border the leftmost 3 cells. To do the
same job as above, you need to also apply Borders(xlInsideVertical) to
the 3x3 selection.

This raises the general question with Excel : is it wise to carry on
using what appears to be an undocumented constant which does the job of
2 "latest" ones .... or apply the new constants as and when they become
current?

It's like vbCrLf, vbCr, vbLf, vbNewLine ... I use the last one as it
makes more sense to me ... I suppose there's no absolute right or wrong.

Regards,

Mark

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!