I have a simple worksheet that I use as a daily calorie counter. And I have a macro that I use to clear it each morning. The problem is that I'm constantly adding new items to the worksheet, so the number of rows and the range that needs to be cleared grows. It can also shrink if I remove something.
I could use a function to count items, but I also have a few blank rows for readability. How best to approach this?
Bookmarks