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
Number to letter
-
nageswaragunupudi
- Posts: 10721
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Been thanked: 8 times
- Contact:
Re: Number to letter
CHR( nCol + 64 ) + LTrim( Str( nRow ) )
Works for values of nCol from 1 to 26
Works for values of nCol from 1 to 26
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India