Hi,

When some other excel file is open and then when i try to run my userform, i get the error message Method 'Range' of object '_Global' failed.

The line of code that is highlighted is ContactForm.Show in ThisWoorkbook.

Kindly help me out on this.

Thanks and Regards
Sivakumar