So I stole this from another excel sheet I had for a similar activity. What I would from this code is, to start from the bottom row with text (not just a formula, a formula is written to return " ") any row that has returned " " above the bottom row that had text in it, in column A, hide that row.
My code is posted below, and my excel sheet is attached. It is the "Mine" sheet that I'm trying to work with
Thank you for any help!
Edit: I guess my issue with the current code is that it only works with the Range A4:A2000. I would like it to work with the entire sheet staring from the last row that returned a value, then hide all cells (up to row 4) that returned " "
Bookmarks