Hank - Thanks,,,
CRAP!! -- I had them both in my Sheet1 module
versus a Standard Module..
Thanks,
Jim


"Hank Scorpio" <ApolloXVIII@Hates.Spam> wrote in message
news:lq6k619uh1pqqqbjsct4d1jbsui8nj3g7s@4ax.com...
> On Sat, 23 Apr 2005 05:46:45 -0400, "Jim May" <jmay@cox.net> wrote:
>
> >Both these functions are yielding/displaying the #NAME?
> >in cell A1 which contains either =ColumnLetter(AB5) or
ColumnLetter($AB$5)
> >or
> >ColLetter(AB5) or ColLetter($AB$5)..
> >Any ideas as to why?
> >Thanks in Advance
>
> Best guess; you have the function definitions in a different workbook
> from the workbook that you have the formulas in.
>
> If the functions below are in your Personal.xls workbook (say), then
> this:
> =PERSONAL.XLS!ColumnLetter(AC15)
>
> should work, but this:
> =ColumnLetter(AB5)
>
> gives me the result you describe.
>
> You might also consider saving the functions into an add-in. (.xla)
>
> >Function ColumnLetter(Rng As Range) As String
> >ColumnLetter = Left(Rng.Range("A1").Address(True, False), _
> > InStr(1, Rng.Range("A1").Address(True, False), "$", 1) - 1)
> >End Function
> >
> >
> >Function ColLetter(Rng As Range) As String
> > ColLetter = Left(Rng.Address(False, False), _
> > 1 - (Rng.Column > 26))
> >End Function
>
>
> ---------------------------------------------------------
> Hank Scorpio
> scorpionet who hates spam is at iprimus.com.au (You know what to do.)
> * Please keep all replies in this Newsgroup. Thanks! *