Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
debug message pops up when I select a range of cells and delete
Hello,
When i select a range of cells and hit delete, a that debug message appears. The range in question is controlled by the following sytax in VB: If target.Row < 10 Or target.Row 13 Then Exit Sub Application.EnableEvents = False If target.Column = 8 Then If IsNumeric(target) = False Then If Len(target) 0 Then target.Offset(0, -2) = "" End If End If End If Application.EnableEvents = True End Sub i have to sometimes select this range of cells all at once and delete, but how can I prevent the debug message from appearing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I'm trying to open an Excel file but a browsing message pops up | Excel Discussion (Misc queries) | |||
How to disable the message that pops up on hyperlinks in XL | Excel Discussion (Misc queries) | |||
Is It Possible To Have... After A Button Press A Message Pops Up ? | Excel Worksheet Functions | |||
EVEN AFTER PUTTING CODE IN VB, THE MESSAGE 'WORKBOOK CONTAINS LINK' POPS UP- HOW TO GET OVER THIS | Excel Discussion (Misc queries) | |||
How do I select a whole range and delete the contents of the cells? | Excel Programming |