Re: UDF producing #NAME?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Bob, I've added it to my file(s).
Jim

"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uYACgW$RFHA.2132@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Jim,
>
> Another version for you :-)
>
> Function ColumnLetter(rng As Range) As String
> ColumnLetter = Split(Columns(rng.Column).Address(, False), ":")(1)
> End Function
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Jim May" <jmay@xxxxxxx> wrote in message
> news:v5pae.26134$gV.17101@xxxxxxxxxxxxx
> > Hank - Thanks,,,
> > CRAP!! -- I had them both in my Sheet1 module
> > versus a Standard Module..
> > Thanks,
> > Jim
> >
> >
> > "Hank Scorpio" <ApolloXVIII@xxxxxxxxxx> wrote in message
> > news:lq6k619uh1pqqqbjsct4d1jbsui8nj3g7s@xxxxxxxxxx
> > > On Sat, 23 Apr 2005 05:46:45 -0400, "Jim May" <jmay@xxxxxxx> 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! *
> >
> >
>
>


.

Relevant Pages

  • Re: [OT] C++ programming: keeping count of data items read from file
    ... HTH ... Kind of defeats the purpose of having string in the first place.) ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". ...
    (Debian-User)
  • Re: Integer to string conversion
    ... I think Jim probably has the best solution but we haven't covered ... templates yet and they seem very confusing, ... I'm trying to convert an integer into a string. ... char buf; ...
    (comp.lang.c)
  • Re: Speed this up for me, please
    ... Many thanks Jim. ... Function Sinfo_R1(ByRef lookupKey As String, ByRef lookupVal As String, _ ... Dim rng As Excel.Range ... The first row of the sheet contains titles for the columns. ...
    (microsoft.public.excel.programming)
  • Re: searching all members of a pds using wildcards
    ... The CA-PDSMAN String Scan and Replace facility allows you to do ... You can specify wildcard character or pattern ... The facility executes online via the EZYEDIT ISPF Productivity Platform, ... Behalf Of Jim McAlpine ...
    (bit.listserv.ibm-main)
  • Re: Whats the error?
    ... Hello Jim, ... > (If I declare ASCIIZ filename in FILE_START ... Sorry, but a string on the command-line is normally terminated by a 0Dh, not ... Maybe you should change the above jump to JBE, ...
    (alt.lang.asm)