Actual Last row needed

[Raghava@rock]

Hi ,

I have Xlsb file where by mistake i have updated formula in a column to last row ( 1048576) and saved it . Now i am trying to reset to actual end last row 1456 .

While i am deleting row , excel gives me error saying that "Excel cannot complete the task with available resources. Choose less data or close applications." Which i tried but no luck.

Request you to help me with this regard.

 

[David Evans]

Try this add-in - http://xsformatcleaner.codeplex.com/

I've never actually used it, so cannot guarantee it's efficacy, but i think it will work for your challenge

 

[Deepak]

http://forum.chandoo.org/threads/vba-code-to-reset-the-last-used-row.29450/