clear range of cells if another becomes blank

[Guest]

I want to clear a range of cells on a sheet if a cell that has a formula
=INF!B2 becomes blank by clearing the data on the INF sheet cell B2

 

[Guest]

=INF!B2

Just hazarding a thought that
perhaps you might be looking for something like this instead:
=IF(INF!B2="","",INF!B2)

Copy the formula across/down as required

 

[Max]

.. on sheet AB in B3 I have

=IF(INF!B2>0,INF!B2,"")

You probably mean in B2, not B3 (guess it's a typo?)

Ok, guess I'm out here. You would need a sub to do what you want. Hang
around awhile for insights from others versed in vba. If nobody jumps in
here, you could put it in a fresh posting (use your better description
below, but corrected for the typo) in excel.programming.

---