JE,

Can you tell me where the UDF is stored? I can't find it in the macro list
where it was created, I don't have the function button available nor can I
seem to find that either (i.e. f* button).

Thanks.

NJDevil

"NJDevil" wrote:

> JE,
>
> After getting the macro to work and refined, I tried your way (after
> learning more about UDFs). It works great. Yes, F9 must be used, but it's
> very stratight forward and the cell is sort of self documenting.
>
> Thank you!
>
> NJDevil
>
> "JE McGimpsey" wrote:
>
> > Make Jim's solution into a UDF. As you're not familiar with UDFs, read
> > David McRitchie's "Getting Started with Macros and User Defined
> > Functions":
> >
> >
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> >
> >
> > Public Function IndentLevel(Ref As Range) As Long
> > Application.Volatile
> > IndentLevel = Ref.IndentLevel
> > End Function
> >
> >
> > Call from the worksheet as
> >
> > B1: =IndentLevel(A1)
> >
> > to find the indent level of cell A1. Note that even with the
> > Application.Volatile command, which makes the function recalculate
> > whenever the worksheet is recalculated, changing the indent level
> > doesn't fire a worksheet calculation, so you'll need to use F9 to be
> > sure it's accurate after changing an indent level.
> >
> > In article <952FB8FA-4144-42FD-B7AE-D597024CDF06@microsoft.com>,
> > "NJDevil" <NJDevil@discussions.microsoft.com> wrote:
> >
> > > Thanks for the reply. However, I don't know how to use that. It sounds
> > > like I need to do some programming to get the info I need. Can you PLEASE
> > > provide me with some code (or how ever you would use it) so that I may
> > > integrate that solution into my spreadsheet? I have spend a lot of time on
> > > this spreadheet and this is the one thing that I really need to make it do
> > > what I need!
> > >
> > > Once I have the code, how do I invoke it in Excel? Sorry for being sucha
> > > newby but I'm not an Excel programmer. I really wish I could just invoke a
> > > function, but the '=CELL' function does not let me query the indent length.

> >