Page 1 of 1

Number to letter

PostPosted: Wed Dec 06, 2017 2:58 pm
by acwoo1
Hi
nRow = 6
do while nRow <= 31
oSheet:Cells( nRow, 13 ):FORMULA := "=" + G7-F7"
nRow = nRow + 1
enddo

How to change number to letter, so that it besomes:
G7 - F7
G8 - F8
G9 - F9

Regards
ACWoo
Using FWH1510+bcc582

Re: Number to letter

PostPosted: Wed Dec 06, 2017 3:04 pm
by nageswaragunupudi
CHR( nCol + 64 ) + LTrim( Str( nRow ) )
Works for values of nCol from 1 to 26

Re: Number to letter

PostPosted: Thu Dec 07, 2017 1:58 am
by acwoo1
Thanks Mr Rao

It works.

Regards

ACWoo