View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bgg bgg is offline
external usenet poster
 
Posts: 2
Default clear range of cells if another becomes blank

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