What is the VBA Code for formatting cells?

[sach_83]

Hi All,

I need to format the borders of some selected cells. I recorded a macro for the same but the piece of code is too long. Please suggest how to program the same effect in one or two lines?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[MarvinP]

Hi sach83,
Doing a quick search on xlEdgeLeft found http://msdn.microsoft.com/en-us/libr...ffice.11).aspx So you are wanting 7,8,9,10 from your code above. How about shortening your 4 codes to:

Please Login or Register  to view this content.

Looking at the linked page you can get the constant numbers for your no_border() Sub and do a loop for it too.

[JBeaucaire]

I like to try this for a complete grid:

Please Login or Register  to view this content.

...and to remove:

Please Login or Register  to view this content.