Unable to add data via userform when another worksheet is open

Hi Guys

I am looking for advice I have a Userform that adds data to a Worksheet called "New Fault Form"

This works great but I cannot add the data to "New Fault Form" when I have a different worksheet open within this workbook

Is there a code I can add that it will add the data to "New Fault Form" when I am using a different worksheet

Thanks

Hi Norie

I have gone through it a number of times

I am getting s Runtime Error '9' Subscript out of range

Please Login or Register  to view this content.

Hi Norie

Not sure if I need to some code to this workbook " to activate the worksheet if I am using another worksheet