Posted to microsoft.public.excel.programming

Soo Cheon Jheong[_2_] Soo Cheon Jheong[_2_] is offline

external usenet poster

Posts: 46

Need a method or function

Hi,

Function LT(ByVal V As Variant) As Variant

V = Trim(V)
If IsNumeric(V) Then
If V = 1 And V <= 26 Then
LT = Chr(V + 64)
Else
LT = ""
End If
ElseIf V Like "[A-Z]" Or V Like "[a-z]" Then
LT = Asc(UCase(V)) - 64
Else
LT = ""
End If

End Function

--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Forecast function calculation method?	Kayote	New Users to Excel	1	April 10th 06 10:23 AM
method and function	mango	Excel Worksheet Functions	0	December 14th 04 11:51 PM
Function or method	Eric Marple	Excel Programming	1	August 5th 04 05:48 PM
Calling a module function from a class method	ranafout[_2_]	Excel Programming	1	November 12th 03 11:08 AM
Method? Function? Operator? I dunno ):	Michael Smith	Excel Programming	0	September 5th 03 09:47 PM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us