Cell "AP65536" ?

[Randal]

I am using the following code to name a range that has data in every cell from column B to column AP.

Set rRange = Range("B2", Range("AP65536").End(xlUp))
ThisWorkbook.Names.Add "TheName", rRange


Problem is that it only define through column "Z" and does not see into column AA. AB etc.

Why does this only work up to column Z? -R-

 

[Greg Truby]

That's working for me. I would try setting a watch on rRange.Address and stepping through the code.

 

[Randal]

Thanks and sorry, my bad. It was the ColumnCount setting in the Properties of the listbox that was limiting the number of columns. After I increased the value the columns came into the listbox. -R-