Setting borders

[HRCalcNStuf]

I've tried:

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

But both give me "Run-time error '438': Object doesn't support this property or method"

Since I can't find anything anywhere on the interwebs or in Mickeysoft's documentation other than "Borders.LineStyle is how you set a border," any hints as to what I might be doing wrong?

[mike7952]

Try this

Please Login or Register  to view this content.

[HRCalcNStuf]

So is it not possible to set:

Please Login or Register  to view this content.

[HRCalcNStuf]

(Without selecting it.)

[mike7952]

This will work

Please Login or Register  to view this content.

or if your wanting the border around all cells in range something like this below

Please Login or Register  to view this content.

[HRCalcNStuf]

Thank you.

So my next question is what's an elegant way to set borders on rMyNamedRange(R,2), (R,4), (R,6-8), (R,14)?

It looks as though I can't define a variable as Range and use the Union command to assign all those to the variable range, which would allow me to set each border once for multiple cells. Do I have to go through each noncontiguous block of the range one at a time?