Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can you ascertain how many "indents" in an excel cell?
I am managing a project and am using the "increase indent" and "decrease
indent" buttons to create my leveling, eg: a level one task would have no indent. A level two task would have one indent. A level three task would have two indents. I then would like to filter my columns by indent level. Therefore, I need how to extract this information from the cell. I note that if you select Format Cells Alignment, the number of indents is shown under "Indent". I have tried the "Cell" and "Info" functions, but they do not have an indent parameter. Thanks Sean |
#2
|
|||
|
|||
If you are doing the filtering with a macro, you can use a statement like:
If ActiveCell.IndentLevel = X Then ........ HTH Otto "seapor@melbourne" wrote in message ... I am managing a project and am using the "increase indent" and "decrease indent" buttons to create my leveling, eg: a level one task would have no indent. A level two task would have one indent. A level three task would have two indents. I then would like to filter my columns by indent level. Therefore, I need how to extract this information from the cell. I note that if you select Format Cells Alignment, the number of indents is shown under "Indent". I have tried the "Cell" and "Info" functions, but they do not have an indent parameter. Thanks Sean |
#3
|
|||
|
|||
You could also create your own function and generate a helper column. Just
paste this into an excel module in your project. Function Indent(x As Range) As Integer Indent = x.IndentLevel End Function In your worksheet, enter =Indent(cell reference) "seapor@melbourne" wrote: I am managing a project and am using the "increase indent" and "decrease indent" buttons to create my leveling, eg: a level one task would have no indent. A level two task would have one indent. A level three task would have two indents. I then would like to filter my columns by indent level. Therefore, I need how to extract this information from the cell. I note that if you select Format Cells Alignment, the number of indents is shown under "Indent". I have tried the "Cell" and "Info" functions, but they do not have an indent parameter. Thanks Sean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcuts for increase and decrease indents | Excel Discussion (Misc queries) | |||
Can you use hanging indents in Excel? | Excel Discussion (Misc queries) | |||
Cells - Top Indents | Excel Worksheet Functions |