| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change message to include range
The want to change the following code:
If Cells(22, 11).Value = "QS" Then MsgBox "Previous code" Exit Sub End If To this: If IsNumeric("I24:I1000").Value If Cells(22, 11).Value = "QS" Then MsgBox "There is data in column I24:I1000, find and delete this data" Exit Sub End If The change to the code is to inform the user that there is data in the range I24:I1000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use RANDBETWEEN form & include certain #'s in the range | Excel Worksheet Functions | |||
| How do I include only visible cells in a range? | Excel Worksheet Functions | |||
| How do i include the original workbook in the email message creat. | Excel Discussion (Misc queries) | |||
| sum a range of cells that include an error | Excel Discussion (Misc queries) | |||
| How do I include a wider range in my code?? | Excel Programming | |||
Threaded Mode
