keep formula

  1. P

    Macro - clear cells but keep formula

    Hello, Can anybody help? I have made a form for my purchase orders and all apart from when i run the macro, it works but has a bug with the following Range("E33:F50").SpecialCell(xlCellTypeConstants, 23).ClearContents I am trying to keep a simple formula i.e =E33 Thanks, Richard
  2. U

    Enter data in cell, but keep formula as well.

    I hope someone can help... Is it possible to have a formula in a cell which can be overwritten by manually entering in a number, but if the manually entered number is deleted, the formula remains in the cell. Thanks in anticipation.....

Some videos you may like

This Week's Hot Topics