Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Good code not working???
The object with this code is that in either of the
worksheets, if the user enters "100" in M15, and "120" in M16, the message comes up. Nothing happens when these test values are entered. Furhter, there are no error messages. Can someone help with this? Does the value in the MyArray have anything to do with it? Sub Descending_Values() Dim MyArray() As Integer ReDim MyArray(3) ' or, the maximum characters in the target cells MyArray(3) = 3 If (Worksheets("1. Customer").[M15] < [M16] Or _ Worksheets("2. Financial").[M15] < [M16]) Then MsgBox "Target cannot be greater than Chart Max" End If End Sub Thanks, Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
And in case I don't see you,good afternoon,good evening,and good n | Excel Discussion (Misc queries) | |||
General tips for good code formatting | Excel Discussion (Misc queries) | |||
Excel drag down formula not working good.. | Excel Worksheet Functions | |||
Excel drag down formula not working good.. | Excel Worksheet Functions | |||
Macro lookup is not working good? | Excel Discussion (Misc queries) |