Unexplainable (to now) error when trying to draw borders

**NiceLittleRabbit** · 12-15-2010, 09:23 AM

Hello,

As part of a large VBA Excel program, I am trying to format some cells by drawing a thick border around range of cells.

The code below works for the first half and bugs for the second half. Indexes are not in question, Excel debugger shows the first .LineStyle = xlContinuous after the second range set.

Does anyone have an explanation why this might be so?

As far as I am concerned, I have a hard time making any difference between the first set of borders and the second.

Please Login or Register  to view this content.

Any help will be much appreciated.

Thank you in advance

**watersev** · 12-15-2010, 09:44 AM

shorter option:

Please Login or Register  to view this content.

**TMS** · 12-15-2010, 09:52 AM

I suspect it has more to do with how you are assigning the range than what you are doing with it.

After you have set the second range, check what its address is in the immediate window.

?rng.address

Regards

**romperstomper** · 12-15-2010, 09:57 AM

Try:

Please Login or Register  to view this content.

**NiceLittleRabbit** · 12-15-2010, 10:16 AM

Originally Posted by watersev

shorter option:

Please Login or Register  to view this content.

I had already tried this, but it produces all the borders (of all cells within the range) to have thick borders, whereas I only want a think border around the range.

However, Excel accepts your code and rejects (sometimes) mine.

Here's the code rewritten so that anyone can check it out

Please Login or Register  to view this content.

As you have guessed, my objective is first to have a good working code, and second to understand why my code did not work ;-)

Thanks for your time in answering and I am looking forward to the next post

**NiceLittleRabbit** · 12-15-2010, 10:24 AM

It works!!!

Thank you romperstomper, watersev and TMShucks for your time and answers

To TMShucks, I think the second code I posted with fixed cells discards the option that the range has not been correctly assigned

I still do not know why it did not work, but I am happy

Thank you all