>I am looking for a quick function that I can use while coding excel automation. Is there a function that you can send a number to and get the alphabet position back for it? For example if I send a 1 I get back A, 3 a C...
>
>Happy New Year!!!!!
If you want this on the VFP side sure, here's one;
LPARAMETERS lnPosition
LOCAL lcLetters
lcLetters = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
IF TYPE("lnPosition") <> "N" OR lnPosition < 0 OR lnPisiont > 26
ENDIF
RETURN SUBSTR(lcLetters,lnPosition,1)