Thank you Mr. Ayush..
Thank you Mr. Bonallack
Best Regards
siti
On Sat, Mar 26, 2011 at 9:43 PM, Ayush wrote:
> Really Awesome formula.
>
> Thanks Siti Vi. I have published this formula on the same page along with
> your name.
>
>
> Regards
> Ayush Jain
>
>
--
--
Really Awesome formula.
Thanks Siti Vi. I have published this formula on the same page along with
your name.
Regards
Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks an
Excellent formula!
Dave.
From: setiyowati.d...@gmail.com
Date: Sat, 26 Mar 2011 16:40:29 +0700
Subject: Re: $$Excel-Macros$$ discussexcel : Macro: Column Number to
Alphabetical reference
To: excel-macros@googlegroups.com
=SUBSTITUTE(ADDRESS(1,A1,4),1,"")
=SUBSTITU
*=SUBSTITUTE(ADDRESS(1,A1,4),1,"")*
*
*
*=SUBSTITUTE(ADDRESS(1,16384,4),1,"")*
On Fri, Mar 25, 2011 at 10:40 PM, Ayush wrote:
> Hello everyone,
>
> Here is the UDF to convert a number into Alphabetical reference. If you
> pass 1 to the function, it will Return A. If you pass 26, It will return
Please try my UDF for the same
Public Function ColumnLetter(N As Long) As String
ColumnLetter = Replace(Replace(Cells(1, N).Address, "$", ""), 1, "")
End Function
On Fri, Mar 25, 2011 at 10:40 PM, Ayush wrote:
> Hello everyone,
>
> Here is the UDF to convert a number into Alphabetical refe
The Excel function =Char() converts a number to the equivalent ASCII character.
So.. =Char(65) is "A"
while =Char(97) is "a"
The equivalent VBA function is chr()
So, depending on what you're trying to accomplish, you can use an "offset" into
this function.
That is to say.. if you're trying to p
