clear range of cells if another becomes blank

B

bgg

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
 
M

Max

=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
 
M

Max

.. on sheet AB in B3 I have
=IF(INF!B2>0,INF!B2,"")
Click to expand...

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.
 
Top