Hello Experts,
I've searched through this Forum's threads about speeding up the For Each....Next loop. There were mentions about variants, LBound, UBound, GoTo, Special Cells, Arrays, storing it in temp memory, etc but I'm unsure how to apply them into my code.

I have 3,000+ rows. Rather than cycling through each cell and performing a command (hide row), is there a faster way to hide entire row if all cells within column A's range with the value of "Hide"? This is code currently takes 6 minutes to cycle through 3,000+ cells, one at a time.

For each ce in rng
If ce.value = "Hide" then
ce.entirerow.hidden=true
end if
next
Thanks in advance,
Ricky