Hi,
In Excel 2007. we have created a large number of spreadsheets from a macro, that has saved the files down with a last visible cell at cell IS1048576...yet the actual last visible cell is BB458. This makes the spreadsheets unwieldy, and indeed we now often get the message that Excel cant complete the task with available resources. I have tried all the tips to make more resource available...but they have not helped.
Is there an easy (VBA) way to force the position of the last visible cell??
Thanks
In Excel 2007. we have created a large number of spreadsheets from a macro, that has saved the files down with a last visible cell at cell IS1048576...yet the actual last visible cell is BB458. This makes the spreadsheets unwieldy, and indeed we now often get the message that Excel cant complete the task with available resources. I have tried all the tips to make more resource available...but they have not helped.
Is there an easy (VBA) way to force the position of the last visible cell??
Thanks