Duke, thanks. The slightly longer versions were to make it a little more
robust, in case new rows / columns are inserted above / left of the starting
cell subsequently. It's something I picked up here along the way, which has
since got a little "stuck-on" as a personal practice, I guess <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Duke Carey" <duke_No_Junk_carey_at_hotmail.com wrote in message
...
Max -

Just a little shorter version of each
=CHAR(ROW(A1)+64)
=CHAR(COLUMN(A1)+64)