Hi There,

I have a userform which is launched from another userform.
When i try to use the second userform (search function) it errors with the following :

Method 'Range' of Object '_Worksheet' Failed
and highlights
Set rSearch = Sheet1.Range("B2", Range("B65536").End(xlUp))

If i run the second userfrom seperately from the worksheet that it references it works fine. Can anyone please provide some assistance?

Forms :
frmDSTCallLog
frmEmailUpdate (References Sheet1)

Thanks,