Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compile error - expected an array | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
compile error: Expected: = ...Why? | Excel Programming | |||
Compile Error: Expected End Property | Excel Programming | |||
compile error: expected variable or function | Excel Discussion (Misc queries) |