LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default Simplify Code for Borders

Trying to work thru all my existing codes to "chop" them into smaller pieces,
clean them up, re-arrange how they work together, etc.

I have seen samples of code for borders that greatly improve the "recorded"
macros. My attempt, as follows, fails, as I really don't know what I am doing.

My Original code will provide instruction as to what range the borders are
reqiured on. Then Call BorderInThin

Sub BorderInThin

With Selection.Borders = Array(xlInsideVertical, xlInsideHorizontal)
.LineStyle = xlSolid
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With

QUESTIONS:
1: What changes required to make the above work.
2: Where can one find detailed definitions of code expressions.
For example, using the "recorded" macro, I can comment out lineStyle =
xlSolid, AND LineStyle = xlContinuous and ColorIndex = xlAutomatic with no
APPARENT change in how the code works. I have to assume I'm missing something
here, as well. I expect some definitions would be a good start.
3: I want to take a course on VBA that starts right back in "kindergarten".
However, everyone seems to have switched the courses to MS Office 2007.
My company is still working with 2003 (and OO).
Is 2007 still using the same language?
If yes, I presume a current course would still be of benefit to learn
the basics I
am missing?
I hope someone can guide me on these issues.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I simplify a VB code?????? hoyos Excel Discussion (Misc queries) 1 November 6th 09 09:06 PM
Simplify Code help DavidH56 Excel Programming 14 September 23rd 08 11:37 PM
Need to simplify code alexwren Excel Discussion (Misc queries) 7 August 15th 06 08:07 PM
simplify code matt Excel Discussion (Misc queries) 3 September 28th 05 11:53 PM
Help to simplify code. Michael Beckinsale Excel Programming 0 September 2nd 03 10:26 AM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"