Hi,
Pls go through the attachment. I want to apply borders (border around & xlmedium) from b2:k21. i wrote a single line of code, there is no errors while running the code but the line of code not applying the borders. pls correct it.
thank you in advance.
regards
shiva
The BorderAround method has frustrated me for years. I stopped bothering with it. This is my alternate method:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi,
Just for information, your code works perfectly for me in that sample workbook in 2010.
Don
Please remember to mark your thread 'Solved' when appropriate.
...and for me in 2010 it fails. That function has frustrated me to tears.
That is indeed strange; I have never once had an issue with it.
Purely out of curiosity, and if you have the time and inclination, does this fare any better
Please Login or Register to view this content.
Grr.... I was certain I had tried that first yesterday, same error for me every time.
https://www.screencast.com/t/XRfI497hOs4h
But now I see from your snippet I was using ColorIndex instead of Color. Your syntax does work for me. That is the first time I've seen this codeline work for me....well...ever. Thanks!
You're welcome. I find it intriguing as I have never had to specify that part unless actually wanting a colour other than the default black.
You can also use ColorIndex that uses index of Colorpalette or one of two constants xlColorIndexAutomatic(-4105) and xlColorIndexNone(-4142).
Color is used if you want to specify color in the form of RGB value
Last edited by bakerman2; 02-22-2017 at 12:53 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks