Forum Discussion
Solved
Excel sheet has 30742 rows, but only 105 have data - how to clean up?
Hi, I have a spreadsheet that has 105 rows of data. I wrote a macro to insert some blank rows between each data row and it took an entire dog-walk to run. The macro finds the last populated row an...
- Deleting the rows and clearing the cells will not update the last row unless you save your file after deleting rows and clearing cells.
Deleting the rows and clearing the cells will not update the last row unless you save your file after deleting rows and clearing cells.
Ick. But OK, I can see why that might be the case.
I just tried it and it did exactly as you said. I have only been at this VBA caper for a week so some of the - how to put this delicately - ah... more arcane eccentricities of Excel are still becoming apparent.
However, it ~is~ bloody marvellous what Excel and VBA can do though. I'm having a rollicking time mucking about with it. I think Excel is possibly the most remarkable piece of software I have ever played with.
Thanks for your help. Your answer is perfect!You're welcome Ploughguy! Glad I could help.
Btw this is default behavior of Excel for last cell and it has got nothing to do with VBA.
And I agree with whatever you said about Excel and VBA. 🙂
Have fun with Excel & VBA!
