chroniclesofdave
New Member
- Joined
- Aug 8, 2016
- Messages
- 48
I have this code:
im getting an error "13 type mismatch" is there any solution to this issue?
Code:
Private Sub sbmt_Click()
Dim irow As Long
Dim wb As Workbook
Dim ws As Worksheet
If NHdata.nhNme.Value = "JOHN" Then
Set wb = Workbooks.Open("L:\NAMES\JOHN\JOHN.xlsm")
Set ws = Worksheets("Data")
ElseIf NHdata.nhnNme.Value = "GRANT" Then
Set wb = Workbooks.Open("L:\NAMES\Grant\Grant.xlsm")
Set ws = Worksheets("Data")
End If
im getting an error "13 type mismatch" is there any solution to this issue?