Type Mismatch Error

[Najwa_X]

Hello Again,

I am having a type mismatch with my Function which is called in the main sub as below :

Please Login or Register  to view this content.

The Function is as below I am having a Type Mismatch with the red line . I think it will continue to other lines . How is it possible to arrange the type wisen the input is a range ?

Thank you for your help.

Najwa.

Please Login or Register  to view this content.

[Fluff13]

Do you have any error values in the first column of the range?

[Najwa_X]

Hi Again,

Actually I have the value #N/A. I changed my code a little bit to

Please Login or Register  to view this content.

[Najwa_X]

Ha !
I deleted the #NA and it worked !

How can eliminate my Sub returning #NA ? By That I mean that I have defined a range Name in Excel till row 1000 as outputs , and if enter data till row 100, The code will run on the 1000 and since no input are there it returns #NA. I steer is a way to clear it easily ?

Thx a lot !
Najwa

[Fluff13]

Has that solved the problem?

[Najwa_X]

Yes it did !
Do you have any idea if there is way ti eliminate the #Na easily ?

I want to give you a reputation I get this message : You must spread some Reputation around before giving it to Fluff13 again. :-(

Thank you.

[Fluff13]

This will ignore any cells with an error

Please Login or Register  to view this content.

[Najwa_X]

Fluff !! I am fan ! You are truly a GURU ! Stay safe dude !

[Fluff13]

Glad to help & thanks for the feedback