Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am creating and using Excel.Style objects and I'm running into problems
with accessing the Borders of an Excel.Style object. 1. The enumerator to access the Top Border "Excel.xlBorderTop" returns the Left Border object. It seems that the enumerators when access the Borders Collection in the style does not match correctly. WHY? and What can I do to rectify the situation? 2. I was finally able to gain access to the TOP border, however the LINE CODE and the WEIGHT of the border was incorrect. WHY? Is there any reason that the Excel.Style object should contain the formatting information different from the Excel.Range object???? Both contain the various formatting options like FONT, ALIGNMENT, PATTERN etc. But for some reason accessing the BORDER information from the Excel.STYLE object produces erroneous behavior... Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
border colors and style | Excel Discussion (Misc queries) | |||
Change border style using VB | Excel Discussion (Misc queries) | |||
Create new border style? | Excel Discussion (Misc queries) | |||
Excel 2003 List does not preserve border style for all rows | Excel Discussion (Misc queries) | |||
Border style of Excel forms | Excel Programming |