I'm trying to use a Select Case to log production time-tables.
I've tried a couple angles - one being Select Case.
Every time I run the Macro I get the default ERROR "Wrong Model Entered...."

Private Sub Transfer()

Dim ModR As String
Dim Count1 As Integer
Dim Count2 As Integer
Dim Count3 As Integer
Dim Count4 As Integer
Dim Count5 As Integer

Count1 = 0
Count2 = 0
Count3 = 0
Count4 = 0
Count5 = 0

ModR = Worksheets(1).Range("B3").Value

Select Case ModR
    Case "Model 1"
        Worksheets(1).Range("B4:B6").Copy
        Worksheets(2).Range("B3:B5").Offset(Count1, 0).PasteSpecial
        Count1 = Count1 + 1
    Case "Model 2"
        Worksheets(1).Range("B4:B6").Copy
        Worksheets(2).Range("B7:B9").Offset(Count2, 0).PasteSpecial
        Count2 = Count2 + 1
    Case "Mode1 3"
        Worksheets(1).Range("B4:B6").Copy
        Worksheets(2).Range("B11:B13").Offset(Count3, 0).PasteSpecial
        Count3 = Count3 + 1
    Case "Model 4"
        Worksheets(1).Range("B4:B6").Copy
        Worksheets(2).Range("B15:B17").Offset(Count4, 0).PasteSpecial
        Count4 = Count4 + 1
    Case "Model 5"
        Worksheets(1).Range("B4:B6").Copy
        Worksheets(2).Range("B19:B21").Offset(Count5, 0).PasteSpecial
        Count5 = Count5 + 1
    Case Else
        MsgBox "Wrong Model Entered / Model Does Not Exist"
    End Select
End Sub

Public Sub call_Transfer()
    Call Transfer
End Sub
I'm thinking the problem lies within
ModR = Worksheets(1).Range("B3").Value
but I'm not certain.

Any suggestions???