Run time Error 380
 

Dear friends,

The following code seems perfectly normal to me and works fine when I start the excel first time. However after couple of trial with the code I sometimes get the following Error.

Quote
Run time Error 380
Could not set the ControlSource property. Invalid property value.
Unquote



With frmFilters
.txtFirstNo.ControlSource = "[" & nameofWB & "]Info!E21"
...
End With

Any idea why.