Calculation formula on Change by Val

[cajand]

Hi,

I use the code below push a calculation formula to U11:U.
I want to execute it with a change by val event. If a cell in the range R11:R511 is changed I want
to execute

Please Login or Register  to view this content.

.
However I only want the macro to set the formula on the same row as the cell that has been changed in R11:R511.

But I can't get it to work. Any help ?: )

Please Login or Register  to view this content.

[TMS]

You need a worksheet change event handler in the sheet where you are making changes:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.