2007: xlsm format holds how many columns?

[Zahra]

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!

 

[Pete_UK]

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

 

[Roger Govier]

After saving as a 2007 format file, you must close the file and re-open.
Then you will have access to the full range of columns and rows.

However, since you say you can only access 70 columns, this is less than the
256 columns of XL97-2003 so there must be something inherent in your code
that is artificially restricting you.
Right click on the sheet tab>View Code and look in the properties of the
sheet to see if there is anything set in Scroll Area.
If there is, delete it and you should then be able to scroll all the way
across the screen.

If that is the case, search the VBA Project for ScrollArea and find the
offending piece of code and amend it, otherwise next time you open the file
you will be restricted again.

 

[Zahra]

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]

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

Pete