Forum Discussion
Excel not updating with Macro
I rarely write macros or VBA code. The reason: although there are definitely legitimate uses for macros/VBA, I've many a time seen it happen that people write code thinking that's the only way to accomplish a given task, without realizing that Excel's built-in functions offer a lot of power and can often accomplish more efficiently and reliably whatever the task is.
So, my goal in saying all that isn't to say "Don't ever learn to write code," but rather to set the stage for asking "What are you actually trying to do?" What is the task here? What is the situation to which you're bringing the toolkit that is Excel? What kind of information is in those rows, the ones you're keeping and the ones you delete? Why are you deleting rows? And so forth.
The purpose of all those questions : you can help the folks here in the Microsoft's techcommunity help you by describing not just your frustration with the macro you've recorded and run, but the bigger picture. In fact, if you could post a copy of the Excel workbook that has frustrated you along with that description of the bigger picture, it would be even more likely we could help.