Macro function only runs once

[Peroni89]

Hi there,

So i've got a function in excel that basically adds up how many yellow cells there are the row.

Please Login or Register  to view this content.

The code works, however not immediately... So, for instance say I make two of the cells yellow, I then have to click backinto the cell in which this function is placed and press enter for the correct number to appear.

Can anyone show me how to make it so it runs any time the worksheet is changed?

I did findsomething about Worksheet.event (sorry something like that) but from my understanding that only works with a sub and not a function.

Any help would be really appretiated!

Cheers

Sam

[stnkynts]

Try using Application.Volatile in your code. Not sure if changing the interior color manually will trigger a sheet recalculation but it should be close

Please Login or Register  to view this content.