| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to return cell formatting?
I am trying to return the format settings for alignment of the active cell
i.e. Text Alignment and Text Orientation. All I get now is -4131 and -4128. I don't know how to interpret those results. I would be grateful if someone could point me in the right direction. Thanks. Alan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to return cell formatting?
I looked up the Range Object in XL/VBA Help and found the description
for the HorizontalAlign property, which can have one of the xlHAlign constants as a value. In the Object Browser I found that -4131 corresponds to the constant xlHAlignLeft. Similarly Help's description of Range's Orientation property shows that it can take on one of the xlOrientation constants as a value. Again in the Object Browser, I found that -4128 corresponds to xlHorizontal. In article , "Alan Ibbotson" wrote: I am trying to return the format settings for alignment of the active cell i.e. Text Alignment and Text Orientation. All I get now is -4131 and -4128. I don't know how to interpret those results. I would be grateful if someone could point me in the right direction. Thanks. Alan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| References omit formatting and return cell address - not data | New Users to Excel | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| Return adjacent cell if conditional formatting exists. | Excel Worksheet Functions | |||
| Conditional Formatting Need to Return to Zero | Excel Worksheet Functions | |||
| Conditional formatting a #N/A return in a cell? I want it white. | Excel Discussion (Misc queries) | |||
Linear Mode
