On Wednesday, April 16, 2014 9:07:57 PM UTC-7, isabelle wrote:
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

Hi isabelle,

I'll give that a go.

Thanks, Howard