1004 (unable to get the weeknum property of the worksheetfunction class)

[rayexcel]

Hi I have this userform that finds,adds and updates data.

When it comes to my update sub I get the error in the title. The code also works out month,monthname,year, from a data entry.

Please Login or Register  to view this content.

[romperstomper]

Try coercing to a date:

Please Login or Register  to view this content.

[rayexcel]

Thanks romperstomper

Worked perfectly!

[romperstomper]

Glad to help. Please remember to mark the thread solved.