Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro that sets a value to a Range varaible. I then want to check
the contents of the variable and if there is no contents I want to give a message in a message box. My code is: Dim rng1 As Range Set rng1 = Worksheets(varWorksheetInfoArray(0)).Cells.Find(va rWorksheetInfoArray(1), LookIn:=xlValues) If IsEmpty(rng1) = True Then MsgBox ("Cannot find " & varWorksheetInfoArray(2)) End If It worked before but now there seems to be a problem since I just get the uninformative Syntax Error. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
runtime error: syntax error or access violation | Excel Programming | |||
runtime error: syntax error or access violation | Excel Programming | |||
variable not declared error & syntax error | Excel Programming | |||
Syntax error. | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |