| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to read in cell border?
Hi, Excel gurus,
When I open an Excel file and read in cell contents and formats, how do I obtain cell border format? I need to know the kind of border (type, style, line thickness, etc) of each cell. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to read in cell border?
On Feb 7, 4:04*pm, wrote:
Hi, Excel gurus, When I open an Excel file and read in cell contents and formats, how do I obtain cell border format? I need to know the kind of border (type, style, line thickness, etc) of each cell. Thanks. Hi Record a macro as you apply these formats and see what you get. regards Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to read in cell border?
On Feb 7, 10:18 am, wrote:
On Feb 7, 4:04 pm, wrote: Hi, Excel gurus, When I open an Excel file and read in cell contents and formats, how do I obtain cell border format? I need to know the kind of border (type, style, line thickness, etc) of each cell. Thanks. Hi Record a macro as you apply these formats and see what you get. regards Paul I am doing this from a VB6 program and I tried to use xlsht.cells(ii,jj).borders.value through all cells concerned. But I get error message of null. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
| Cell border | Excel Worksheet Functions | |||
| Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
| Cell Border | Excel Discussion (Misc queries) | |||
| only last cell on page to have bottom border (cell area outline) | Excel Worksheet Functions | |||
Hybrid Mode
