Compile Error: Expected Array
Greetings All
Getting error: Compile Error: Expected array in the following code:
Sub WhoAreYou()
Dim Workbook As Long
Dim Worksheets As Long
' The following WorkBook is NOT Open/Active
If Workbook("C:\Excel
Add_Ins\QCNum.xls").Worksheets("Sheet1").Range("C_ C_TJM_JFS") = "TJM" Then
Call CC_Message1 'Opening message for required code
End If
If Worksheets("QCNum.xls").Range("C_C_TJM_JFS") = "" Then
Call Notxxx 'Message "not available to you" and exits procedure
End If
End Sub
How to make this work, please?
|