2007: xlsm format holds how many columns?
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 tabView 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.
--
Regards
Roger Govier
"Zahra" wrote in message
...
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!
|