Code: Cell Border

**walid66** · 11-04-2010, 06:57 PM

I would like to know if there is some more efficient way to create cell border beside the recorded code below.

thanks

Please Login or Register  to view this content.

**TMS** · 11-04-2010, 07:03 PM

Please Login or Register  to view this content.

Regards

**walid66** · 11-04-2010, 07:21 PM

Thanks it worked

**shg** · 11-04-2010, 09:20 PM

Or

Please Login or Register  to view this content.

**TMS** · 11-05-2010, 02:25 AM

@shg: Good Grief! I never realised you could do that. Doh! Thanks.

**shg** · 11-05-2010, 09:17 AM

I learned from someone else's example, just like you.

What is curious to me is that the Borders collection includes just 4 borders (l/r/t/b), but you can index eight different members by name (edge l/r/t/b, inside h/v, diagonal u/d). It may be convenient, but it's startlingly inconsistent.

**TMS** · 11-05-2010, 11:45 AM

@shg: and yet, when you select a 2x2 cell matrix, you get borders around all four cells.

I have yet to use diagonal boders ... although I'm sure there are lot's of uses, if I did but know.

Regards