![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Putting Borders around cells in Excel Topic Summary: Created On: 12-Aug-2008 21:05 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Anyone know how I would put a thick border around a range of cells once I've all gotten a OleAutoObj for the range of of objects?
------------------------- Scott Boisvert Engineering Tools Administrator L-3 Communications - Avionics Systems scott.boisvert@l-3com.com |
|
![]() |
|
![]() |
|
Sutherland's excel exporter has functions to set a ranges border.
------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com |
|
![]() |
|
![]() |
|
That's what I was looking at, and how go the range using his getCellRange function, but can't find anything related to setting a border.
------------------------- Scott Boisvert Engineering Tools Administrator L-3 Communications - Avionics Systems scott.boisvert@l-3com.com |
|
![]() |
|
![]() |
|
Here you go. Sorry. You'll have to find the integer value for bold borders. Just do a macro and add a bold border. Should give the value. If it uses an identifier instead of the value you can google it typically.
------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com Edited: 12-Aug-2008 at 22:17 by David Pechacek |
|
![]() |
|
![]() |
|
The integer specifying a "Thick" border would be 4. I used the Object Browser in the VBA editor -- there's a group called XlBorderWeight.
|
|
![]() |
|
![]() |
|
This is how I was able to get this to work:
------------------------- Scott Boisvert Engineering Tools Administrator L-3 Communications - Avionics Systems scott.boisvert@l-3com.com Edited: 14-Aug-2008 at 14:26 by Scott Boisvert |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Putting Borders around cells in Excel
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.