Well, I'm glad you got to the bottom of it - thanks for feeding back.

Pete

On Feb 5, 4:22*pm, Zahra wrote:
Thank you Pete and Roger,

I did take a longer look after I posted. *The columns were hidden, so it was
a matter of finding the right keyword to search in the VB code and amending
the code. *I'm no programmer (though I'm told I have the kind of mind to be
one), but it was as simple as replacing "BV" by "DV" in the proper line.



"Pete_UK" wrote:
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!- Hide quoted text -

- Show quoted text -