help with re-calculating Excel UDF

[alienscript]

Hi VBA community!

In the worksheet I have a UDF to count the number of cells filled with the different color background. However, sometimes when I added or removed some colors, or deleting rows, the code below didn't work to recalculate the UDF, except when I pressed F2 and press Enter.

Appreciate any help with a code how to allow the UDF to recalculate when I press the common button. I'm using Excel 2003.

Thanks!

    Application.Volatile
    Application.Calculate
    ActiveWorkbook.RefreshAll

[GTO]

Maybe try:

    Application.CalculateFull

Hope that helps,

Mark

[alienscript]

Thanks GTO! It works.

[GTO]

Happy to help!