Syntax To Add Workbook & Worksheet To IfError Function

[Genus Max]

Hi,

I'm trying to add Workbooks("Main.xlsm").Worksheets(1). to n = WorksheetFunction.IfError(Range("a10").Value, 0), but cant figure out the syntax.

Thanks.

The fullcode :

Please Login or Register  to view this content.

[dangelor]

As written, it works fine as long as the value of A10 is an integer or an error.