Thanks for your reply. The problem is that I am using the formula
=NETWORKDAYS(G8,H8). Then a macro will copy this formula all the way down in
the column until there is data available. In some rows, there G or H is
empty and then I get the error mesage. I need to use a macro. Could you
help me with ti please

"orquidea" wrote:

Hi All

Could anyone please help me to write a subprocedure wich replace the cell
with the error note #VALUE! with the comment "No Info"
I have the below

If ActiveCell.Value = numero (I don' know how to tell the computer
that any number is valid) Then
ActiveCell.Offset(1, 0).Select
Else
ActiveCell.Value = "No Info"
End If

Thanks,
Orquidea