Delete rows with #N/A values on my sheet using VBA code

[joh46k]

Iam new to VBA Excel!

Problem- After i click my update button in my userform.My data is updated successfully but at the same time , i see some #NA for those,I did not entered any data. i don't want to see any #NA on my sheet . what i should do?

Note : I used "For With loop" in my update button...the code is below .pls chk it!!

Please Login or Register  to view this content.

[rcm]

use the iferror() statement for every entry

[joh46k]

How to do iferror() statment ?

i donot where to put?

Please some one help me on my post #1

[joh46k]

Bump no response

[rcm]

OK vlookup will return a #N/A if the seeked string is not found so
if you rewrite iferror(Vlookup(... ),"") you will get a blank cell and not a "#N/A"

[joh46k]

@rcm: ok , if that is the solution for my code, then my question is how to write a iferror() statement code ?

Please Reply Thank you!!

[joh46k]

It's ok guys!! i solved it. Thank u for ur Precious time to reply me back .

[Trebor76]

Hi joh46k,

Try this single line of code for the Product_Hirechy macro...

Please Login or Register  to view this content.

...and this single line for the Flow_Description macro:

Please Login or Register  to view this content.

Regards,

Robert