Delete formula

**rz6657** · 09-15-2009, 02:12 PM

I need a code that will recognize when D5 is blank that it will delete / empty the contents of E5 automatically (and so on for D6 and E6). I want it to occur for D5:E6 thru D41:E41.

Thanks,,,

**sweep** · 09-15-2009, 02:39 PM

Hi,

This code will do what you want. You will need to adjust the sheet reference as required.

Please Login or Register  to view this content.

**rz6657** · 09-15-2009, 03:04 PM

thanks for the reply. Where do i place the code? It's not working so i may be doing something wrong....

**JBeaucaire** · 09-15-2009, 03:11 PM

"Delete" sounds like an action and not a calculation. In this forum we are looking to solve things with worksheet formulas.

Do the cells you want emptied have values in them or formulas? If formulas, we can adjust the formula to stay visually "blank" when D5 is empty. Like so:

E5:
=IF(D5="", "", yourcurrentformula)

If you want values to get removed, you'd need to post your question and a sample worksheet in the Programming forum.

EDIT: Sorry, sweep has offered a programming solution. Although it's not automatic and only applies to one row, it is a start in the direction you've described.