Application Defined or Object Defined Error Run time error 1004

Please Login or Register  to view this content.

Possibly because in VBA, year is a VBA function to extract the year from a date. I'm pretty sure you can't name a variable the same as a function name.

Paul, you can name a variable with the same name as a function, but you should absolutely avoid such situations. If the variable is not declared, the compiler interprets it as a function, which may result in an error, as in this case. Compare the operation of the three procedures. It is assumed that there is no Option Explicit directive at the beginning of the module.

Please Login or Register  to view this content.

Artik