Worksheet Change with a filldown

[Always_A_Newbie_2]

Hi,
Say I have 2 columns A + B. A holds user input and B holds a formula. I didn't want the user to have to keep dragging the formula down so I made a filldown+worksheetchange sub. Works fine, but I've discovered that if I "cut" info out of a cell and paste in in the one below the filldown doesn't occur, which means that the Worksheet_Change Sub isn't being called.

Could anyone tell me why Cut, and probably copy don't call this Sub (paste doesn't call it either for me), and any possible way around this?

Thanks

 

[Always_A_Newbie_2]

Svp aide, je suis stupide (babelfish)

 

[BrianB]

Works OK for me (XL97). It should work because the target cell value is changed by the process. Does the rest of your code stop the macro if the activity is outside a particular range ?