| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shorter method to "box" some cells
I am using Office 2003 on Windows XP.
I simply want to draw a box around a single cluster of cells, but I find, using the recorder that you have to use at least four lines of code to do this: Selection.Borders(xlEdgeLeft).Weight = xlThin Selection.Borders(xlEdgeRight).Weight = xlThin Selection.Borders(xlEdgeBottom).Weight = xlThin Selection.Borders(xlEdgeTop).Weight = xlThin Isn't there a one line method that is easier/faster (something like xlBox)? Thanks in advance for your assistance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Shorter method to "box" some cells
Try this...
selection.borderaround xlthin -- HTH... Jim Thomlinson "quartz" wrote: I am using Office 2003 on Windows XP. I simply want to draw a box around a single cluster of cells, but I find, using the recorder that you have to use at least four lines of code to do this: Selection.Borders(xlEdgeLeft).Weight = xlThin Selection.Borders(xlEdgeRight).Weight = xlThin Selection.Borders(xlEdgeBottom).Weight = xlThin Selection.Borders(xlEdgeTop).Weight = xlThin Isn't there a one line method that is easier/faster (something like xlBox)? Thanks in advance for your assistance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Shorter method to "box" some cells
In my first post you probalby get the wrong kind of line. Weith is the second
argument so just add a comma selection.borderaround , xlthin -- HTH... Jim Thomlinson "quartz" wrote: I am using Office 2003 on Windows XP. I simply want to draw a box around a single cluster of cells, but I find, using the recorder that you have to use at least four lines of code to do this: Selection.Borders(xlEdgeLeft).Weight = xlThin Selection.Borders(xlEdgeRight).Weight = xlThin Selection.Borders(xlEdgeBottom).Weight = xlThin Selection.Borders(xlEdgeTop).Weight = xlThin Isn't there a one line method that is easier/faster (something like xlBox)? Thanks in advance for your assistance. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Shorter method to "box" some cells
Exactly what I was looking for, thanks...
"Jim Thomlinson" wrote: In my first post you probalby get the wrong kind of line. Weith is the second argument so just add a comma selection.borderaround , xlthin -- HTH... Jim Thomlinson "quartz" wrote: I am using Office 2003 on Windows XP. I simply want to draw a box around a single cluster of cells, but I find, using the recorder that you have to use at least four lines of code to do this: Selection.Borders(xlEdgeLeft).Weight = xlThin Selection.Borders(xlEdgeRight).Weight = xlThin Selection.Borders(xlEdgeBottom).Weight = xlThin Selection.Borders(xlEdgeTop).Weight = xlThin Isn't there a one line method that is easier/faster (something like xlBox)? Thanks in advance for your assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
| Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
| What's the equivalent way of "Cells" method for the C++(ATL) | Excel Programming | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
