create an alert or pop-up window when #NUM! or #REF! appears in a cell

[Skidood]

Good day folks

As the title implies, I want to create a noticeable alert for the user if #NUM ! or #REF ! appears even once within a range of cells occupying one column ( ie column BX, Rows 10 to 1000.)

Any takers?

 

[Fennek]

Hi,

try, if this code works:

if not Range("BX10:BX1000").specialcells(3,16) is nothing then msgbox "Error"

The key is specialcells(3,16), maybe you have to check other ways.

regards