It should go beyond 16,000 columns, so you need to look at your macro
again - post it here if you can't discover where it is going wrong.

Pete

On Feb 5, 3:32*pm, Zahra wrote:
Hi,

We've been using Excel 2007 for a while and we have a small problem: one of
our macro-based worksheet can't go beyond column BV (about 70 columns, I
guess). *That worksheet used to be in 97-2003 xls format and we re-saved it
as a xlsm file. *Is it a limitation that comes from the file format or is it
a limitation we might have created inadvertently?

Thank you for your help!