VBA code to reset the last used Row

[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.

 

[YasserKhalil]

Try to clear the contents instead of deleting then save the workbook ..

 

[Deepak]

Duplicate

http://chandoo.org/forum/threads/actual-last-row-needed.29451/