Code not working
Thanks, Bob. I'll get working on it.
-----Original Message-----
Phil,
Nothing can be assumed, you must spell every test out
fully, and include
Worksheet object, and the dot operator.
IF Worksheets("A").[A1] < Worksheets("B").[M1] OR _
Worksheets("A").[A1] < Worksheets("B").[M2] or
etc.
--
HTH
Bob Phillips
"Phil Hageman" wrote in message
...
Excel 2000
This module code is inteded to give the user a message
when improper data is entered in either the Customer or
Finance worksheet. It isn't working. The "If..." line
is
colored red.
Sub On_Update()
If (Worksheets("Customer")Or ("Finance")[M15] < [M16] Or
[M47] < [M48] Or [M79] < [M80]) Then
' MsgBox "Target cannot be greater than Chart
Max"
End If
End Sub
Where am I going wrong?
Thanks, Phil
.
|