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.
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.
![]()
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks it worked
Or
![]()
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
@shg: Good Grief! I never realised you could do that. Doh! Thanks.
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.
@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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks