Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

strange error in Excel

Status
Not open for further replies.

WebStar

Programmer
May 1, 2002
69
DE
hi there,
everytime I let excel opend when I lock the station I get a strange error when I try to run the macro after unlocking. If I close excel and open it again, everything works fine.
The error I recive is this:

Run-time error
'-2147352571(80020005)'
Type mismatch

does anyone knows what this error is?

thank you!
 
Can you post your code ?

Sounds like your declaring a variable as a certain type
 
The code is very big and if I don't lock the station, or I restart Excel after unlock, it works perfect. I recive this error only if I let Excel opend while the station is locked.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top