Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code is not correct
The following code is not correct.
If WorksheetFunction.CountA(Range("I28:I950")) 0 Then If Cells(21, 11).Value = "QS" Then MsgBox "There is data in column I28:I950, find and delete this data. You cannot have any data in the Quantity Ordered column when you are creating a Quick Sale invoice. " Exit Sub End If End If There is a formula in cell in the range I28:I950 For eg. =IF(J76="","",J76) I will appreciate any and all help. Thanks Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to search for a code, and have the correct information auto fi | Excel Discussion (Misc queries) | |||
#Value! error on code that should be correct? | Excel Discussion (Misc queries) | |||
Code for Correct location of Add-ins for all versions of Excel | Excel Programming | |||
Help to correct code | Excel Programming | |||
Can you help with the correct translation of this code? | Excel Programming |