• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to place borders from one plan to another Plan

Hello SPP,

You could try this:-

Code: 
Sub Test()

Plan1.Range("B4:B10").Borders().LineStyle = Plan2.Range("B4:B10").Borders().LineStyle

End Sub

I hope that this helps.

Cheerio,
vcoolio.
 
Last edited:
vcoolio
Good Morning!

Thank you for your help
But stay with continuous line
I would spend with the same border style
 
Hello SPP,

I don't understand your meaning. Your opening post asks how you could copy the borders in the range B4:B10 from Plan2 to Plan1.

The little piece of code in post #2 does exactly that.

I've attached your sample workbook with the code implemented and assigned to the "TEST" button in Plan1. Have a look at the borders in Plan2 B4:B10 then go to Plan1 and click on the button. You'll see the same borders copied to the same range in Plan1.


Cheerio,
vcoolio.
 

Attachments

Hi !​
​
Via Excel basics : Copy the source range and on the destination range Paste Specials the format only,​
so easy just activating the Macro Recorder …​
​
 
Hello SPP,

No, they don't. You have what you asked for (copying the borders B4:B10) so you've just confused everyone here with your changing requests!

Cheerio,
vcoolio.
 
You must log in or register to reply here.
Back
Top