Using code, you would have to do it by either exclusion ( If not something or
<> something or > something or < something) or by inclusion (If = something
or Like something).  If all the ranges you want to skip are blank, for
instance, you could use:  If Not IsEmpty(Selection) then do something  :  If
the cell is blank, it would be skipped and move on to the next one.  This
approach could be used with the For...Each...Next method where each cell is
tested for the condition.