When I use the macro recorder for adding borders around a chart it does this mess:
Can anyone give me the most simplified code for achieving a basic border?Please Login or Register to view this content.
When I use the macro recorder for adding borders around a chart it does this mess:
Can anyone give me the most simplified code for achieving a basic border?Please Login or Register to view this content.
Try
or evenPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by WasWodge; 11-28-2012 at 02:28 PM.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
How about this?
Please Login or Register to view this content.
WasWodge's suggestions are much more efficient.
Perfect. Thanks!
WasWodge's code didn't work after all. What am I missing?
I tried all three suggestions, including mine, and they all work for me.
I think if none of the suggestions is working then you will need to post a copy of your workbook (sensitive data removed )
That's so weird. I tried it again in a new workbook and the single line works perfectly. So simple. Something must have been going on with my last workbook.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks