Type mismatch error in IfError and Round Function

[RiaMelissaJaravata]

Hi,

I don't know why this always return "Type Mismatch" error. I just used the IfError function because I have #DIV/0! in the cell I want to copy and I just wana #DIV/0! to just show "0"
Here is my code:

ThisWorkbook.Sheets("Sheet1").Range("E5").Value = WorksheetFunction.IfError(Round(ThisWorkbook.Sheets("Sheet2").Range("J22").Value, 0), "0")


I hope you can help me. Thank you!

 

[MaunishP]

Hi Ria,
If you want to use formula in cells, then try below given formual. Insert this formula in cells where you want output as " 0 "

= IFERROR(A1,"0")

Regards
Maunish Patel

 

[NARAYANK991]

Hi ,

Remove the ROUND ; use :

ThisWorkbook.Sheets("Sheet1").Range("E5").Value = WorksheetFunction.IfError(ThisWorkbook.Sheets("Sheet2").Range("J22").Value, "0")

Narayan

 

[RiaMelissaJaravata]

Hi Narayan, how will I round off the values so that it won't have any decimal point?

 

[RiaMelissaJaravata]

Hi Maunish Patel, thank you for the tip, this worked!

Also, thank you Narayan, I removed the ROUND and it worked. Thanks a bunch!