I am a bit confused about the purpose of the Values property of the borders object.
1. What are all possible values? Seems to be only 1 - 12 or so.
2. This appears to do the same thing as the XlBordersIndex constants and the LineStyle property of the borders object.
It is the same as LineStyle. There are almost always more than 1 way to do things in VBA.
I don't know for sure but it is probably a carry-over from previous versions of BASIC.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks