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
___
From: Ayush
To: excel-macros@googlegroups.com
Sent: Fri, March 25, 2011 11:40:11 AM
Subject: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical
reference
Hello everyone,
Here is the UDF to convert a number into Alphabetical reference. If you pass 1
to the function,
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 Z. If
you pass 27 It will return AAand so on.
http://www.discussexcel.com/learn-macros/vba-macros
Let me know if you have better s
