Syntax Error?

[bmasella]

This syntax worked in Excel 2007 but for some reason after upgrading to 2010 no such luck...

What did I miss?

Please Login or Register  to view this content.

It is actually erroring on Chr(10) and on Error(Err)

Cant Find Project or Library

[DGagnon]

Im assuming its part of a larger code, the syntax for that line it self works, tested in a fresh module.

could be something with that praticular file? is recreating the file an option?

try checking your references to make sure all the standard references are selected.

[shg]

In the VBE, Tools > References, look for a ticked reference (they are all at the top) that starts with MISSING. Untick it.