Problem with finding a MATCH in a Range

[j_Southern]

The following code takes values from a userform and puts them in the required place of the required worksheet.

Please Login or Register  to view this content.

When this is triggered (by a button on the user form ), if it is directly after opening the application this fails with a error message "Method Range of object __Worksheet failed"

If I then restart the application by clicking Run when the userform code is showing it runs as required with the data put in the correct place.
I need some help to understand what is going wrong.
John

[Fluff13]

Without knowing where it fails, or having a workbook to test on, this is a guess.
Try adding a . before cells on this line

Please Login or Register  to view this content.