Worksheet change dont work well with formula

[dairin]

I have this VBA that works very well with the worksheet change but when I use formula in the range stated, it doesnt work when there is a change in formula result then it will change all the cell with formula to non-formula cell value.
Any one able to help so the VBA able to work on the range with formula.
I want to make range D:D fill with formula (e.g. A1/B1)

Please Login or Register  to view this content.

[romperstomper]

A formula calculation will not trigger the Change event. You'll either need to monitor the cells that the formula refers to, or use the Worksheet_Calculate event.

[dairin]

I tried that but no success and it just messed up everything that works well previously

[romperstomper]

That doesn't really help us to help you. What did you try exactly and what actually happened?

[saravnepali]

I tried that but no success and it just messed up everything that works well previously

If you can provide a specific example (possibly with a workbook attached) on what you tried, AND what didn't work as you would have expected to work