hi Howard,

you can replace
Chr(rngC.Column + 64)
by
Application.Substitute(rngC.Address(0, 0), "1", "")

isabelle

Le 2014-04-16 17:49, L. Howard a écrit :
Upper case Chr are from 65 to 90 and I see where + 64 would make column 1 into column A.
The N column limit has me stumped. Have not tested it on double letter columns.

Howard