Setting worksheet as variable

[jUStPunkin]

Hello.

I'm sure this is something very simple and I am missing it, but I can't figure out why I'm getting an error on this:

 Dim WS1 As Worksheet
    Dim WS2 As Worksheet
    Dim WS3 As Worksheet
    Dim FeedType As Range
    Dim SlotOrHole As Range
    Dim Redist As Range
    Dim RDesignHead As Range
    Dim DesignHead As Range
    Dim RTDHead As Range
    Dim TDHead As Range
    Dim RTUHead As Range
    Dim TUHead As Range

    
    
    Set WS1 = Worksheet("Input")
    Set WS2 = Worksheet("Spouts")
    Set WS3 = Worksheet("Spouts2")

When I run this, it highlights the work Worksheet in the first set, and the error is compile error: sub or function not defined.

 

[6StringJazzer]

Change Worksheet to Worksheets in the last three lines.

 

[Fluff]

Those 3 Set lines should be Worksheets (plural)

 

[jUStPunkin]

I knew it was something simple - thanks for the quick response!

 

[Fluff]

Glad we could help & thanks for the feedback.