Transfering Data From Userform To Sheet Under Relevant Column And Row

[paul_pearson]

Thanks

I get an error - subscript out of range

I think it may have to do with the sheet names....

I changed the sheet names in code but still error

Thanks

Paul

[bakerman]

Makes sence. Where is this sheet.

    With Worksheets("LENTICULAR-MEMBRANES")
        .Unprotect Password:="1357"
        .Protect UserInterfaceOnly:=True, Password:="1357"
    End With

Also you use the Tag-property to check for empty objects but in not one object you've filled in the Tag-property. In this case this will never work properly.