Hi Jacob,

I saw your post for getting the indent level on a particular cell, but I must admit this wasn't enough information for me to create a macro that will return the information I want.

I would like to get the indent level property from one column of cells say, range("B1:B500"), and show then in another column ("A1:A500"). I am no VB programmer, but I do have some rudimentary understanding of the syntax.

Anymore detail would be appreciated

Thanks,
Pat

On Monday, March 23, 2009 2:01 AM Mu wrote:

Hi,
Is there any way to check the Level of Indentation in a cell through macro ?

If so Please help me out Thanks in Advance
Muk


On Monday, March 23, 2009 2:18 AM JacobSkari wrote:

Range("A1").IndentLevel will give you the values 0,1,2,3...


If this post helps click Yes
--------------
Jacob Skaria


"Muk" wrote: