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

[nErD]

Dear forum members,

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

 Set From_Sheet_SDE = Filename_FROM.Worksheets("SDE")

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]

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:

Set From_Sheet_SDE = Filename_FROM.Sheets("SDE")

[nErD]

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