VBA to Add Borders

[Dal123]

Hey Guys, I've watched quite a few tutorials and read many articles now regarding borders and after spending all day and trying most combinations I cannot get this to work.

Please Login or Register  to view this content.

I've already tried:

• Changing the HeadersID to a speicific range; incase the With cmd cannot address Range Names
• .LineStyle:= xlContinuous
• And many, many, many other combinations.

The best tutorial is https://youtu.be/JT6C07BzWGk and I've followed it exactly apart from referring to a range name but I cannot get it to work; which makes me think there's something wrong with my VBA?

[pjwhitfield]

try

Please Login or Register  to view this content.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[Dal123]

Thanks guys, I spent all day on this. I swear I had it like that too. Really angry at myself for spending a day on this.

Massive thanks to you both.

[Dal123]

Sorry guys, I'm really struggling with borders. What's the deal with the .BorderAround method?

I'm getting errors again around the .LineStyle

Please Login or Register  to view this content.

I've tried:

Please Login or Register  to view this content.

Sorry to abuse your kindness here guys.

[AlphaFrog]

Please Login or Register  to view this content.

You can highlight the BorderAround keyword in the VBA editor and press F1 for syntax help and example code.

[Dal123]

Thanks Alpha, cool feature I wasn't aware of there so thanks very much.

It seems like this is identical to the VBA help, I have it carrying out the code so no syntax errors but it's not actually displaying a border. Just when I think I have it sussed it kicks me in the teeth; lol.

Please Login or Register  to view this content.

[AlphaFrog]

It's not identical to the help. Did you try the one line I suggested without the With statement?

I think your issue, in this case, is not understanding the difference between an Object and a Method. The With statement refers to a an Object like the .Borders collection of a Range . So you can use the With statement for say a Range("A1").Borders

The .BorderAround is a method (not an object). You cannot use the With statement on a method.

Understanding Objects, Properties, and Methods

[Dal123]

Thanks Alpha, I get what you're saying. I've spent two weeks 14 hours a day watching tutorials creating the files and following lessons. I should understand this; really disappointed in myself. Thank you greatly for your input - much appreciated.

Yeah I copied that baby in but no joy, I also tried ActiveSheet. infornt of it.