I didn't even consider what the LEN meant. I thought it was taking away any spaces. If I was writing it in Embed Formula I would write =IF(F1<>"","messagebox","donext")
I did it! I made all the sheets to show up! I just got rid of all the LEN, TRIM stuff.
If Range("F3") = "ALL" Then