How to fit rectangle with big size in a middle of a range

[gaului]

Hi everyone,

After searching I got my rectangle placed center of Range("A1:J18"). But if I change size of width and height to lagre numbers, my rectangle goes outside the box (Range("A1:J18")).
Is there anyway to keep my rectangle fit inside the range but still scale regard to size of width and height? Below is the code center rectangle in a range. I also attached file that I am doing. Hope you guys can help me. It is much appreciated. Nice day all

Please Login or Register  to view this content.

[quekbc]

Untested, but perhaps something like...

Please Login or Register  to view this content.

[gaului]

Thanks quekbc, I tested and it doesn't work

[quekbc]

Can you give more info than that? What about it that doesn't work?

[gaului]

I copy your red code to my file, then run it.
I tested it with width = 600 , height = 500, and I also tested in small cases with width or height greater than maxwidth, maxheight. The rectangle still went outside the box.

[quekbc]

Hmm... I can see the issue with width = 600 and height = 500 as my code will deal with one but ignore the other... so... try this.

This should at most put the borders ON the box's line, but not outside.

Please Login or Register  to view this content.

[gaului]

Thanks quekbc. It is working now . Can I ask you one more question? If the width or height with bigger size, it goes with exactly as same as maxwidth or maxheight, but the ruler then goes outside the box. Is there anyway to have padding or margin to have the rectangle and its height/width ruler inside the box?

[quekbc]

You need to make sure your check the BeginY and EndY. If they are outside the box, move it inside. Something like...

Please Login or Register  to view this content.

[gaului]

Thanks quekbc. Actually, I understand your suggestion, but I don't know how to apply it into my code. Maybe I will work around with the first solution you gave.
Anyway, your help is very appreciated. Thaks again and take care

[quekbc]

hi gaului,

I've added this line just before you create your horizontal line. I've also attached a sample file here.

Please Login or Register  to view this content.