After vba use my formula stop working as the vba replaces cell values

Hi ROHAN999
You are not giving us enough infomation.
We cannot help you if you do not give us more detail of the problem.
We can only give general ideas if you only give us brief details of your problem.
http://www.excelforum.com/showthread...t=#post4494031
We need to see your code and / or your workbook.
You must explain to us what you want.

If you delete a column that is referenced in a formula then it is obvious that the formula will error after the column is deleted.

You must tell us what you want to happen.

My solution will replace the formulas with the value they give prior to the column being deleted.

If you wish something else to happen then you must tell us what. For example, you could move the column instead of deleting it_..

    Columns(4).Cut
    Columns(100).Insert Shift:=xlToRight

Alan