Last Visible cell selector

[FinPerf]

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

 

[masterjee]

error shows when your files are corrupted try to fix a "dot" at a particular cell

e.g.

Range("r452').select
activecell.formular1c1 = "."

after opening sheet press ctrl+end button you are at and of data or hide particular array