[SOLVED] Type Mismatch 13 - setting worksheet to another worksheet not working

**nErD** · 01-03-2012, 08:07 AM

Dear forum members,

I receive a runtime error 13 (type mismatch) when I try to set a worksheet to another worksheet; the code

Please Login or Register  to view this content.

gets highlighted. I am a novice when it comes to VBA; I have coded quite a bit of MATLAB and Python though, so I have an understanding for algorithm theory.
Your help in finding why Excel thinks the two worksheets are incompatible is highly appreciated.

The code in its entirity is a bit too long for this thread; I have attached it as a file instead.

**Andrew-R** · 01-03-2012, 08:13 AM

I think that From_Sheet_SDE should be defined as worksheet object, not a worksheets object and, because you want a single sheet, your set statement should be:

Please Login or Register  to view this content.

**nErD** · 01-03-2012, 08:40 AM

Andrew, that most certainly did the trick! Thank you very much, my problem is now solved.

I changed:
1. in the difinitions, Worksheets to Worksheet and
2. in the code quoted above, Worksheets to Sheets