I can get the VBA to work just fine to do this, but my spreadsheet is 20MB without data. What I want to do is find the first time a cell is blank and then hide every row at once from that spot until the end. Here is my code that works:
Dim rl As Range For Each rl In Sheets("Results").Range("$A$4:$A$800") If rl.Value = "" Then r1.EntireRow.Hidden = True Else: rl.EntireRow.Hidden = False End If Next rl
So in this example, if r1.value = "", I want to hide from that row all the way until row 800. Any advice?