Hi all, I need to add a button to an excel spreadsheet that will hide all rows that have a blank cell in column A1. I'm pretty sure this is achievable as I've managed to do it to hide blank rows but I only want them hidden if only column A1 is blank. Hope this makes sense. Can anyone help?