Hello Experts!

I have a single range B2:B50. Within this range are three contiguous ranges
that are ever-shrinking or expanding depending on user input. At one point,
the ranges might go B2:B10, B11:B40, B41:B50, but at the very next point, the
ranges might change to B2:B17, B18:B34, B35:B50. I never know.

The visible change is this: the target range will have data figures and the
other two will turn to Zeroes. I need a dynamic range formula that finds
just the non-zeroed range in the column.

Please help. You always have in the past.

Thank you for your time.

Arlen