View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BEEJAY BEEJAY is offline
external usenet poster
 
Posts: 247
Default 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?