| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting cells that are controlled using Target code
I have columns that are set up to automatically respond when they contain the
target cell. The code below all works fine. My problem is that when I finished I need to clear these cells. I am currently doing this by selecting a range and making it equal to "". This causes an error in the code below. Is there some way of disabling the target code when I delete the range. Thanks If Target.Column = 11 Then Target.Offset(0, 1) = WorksheetFunction.Max(Range("L:L")) + 1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting cells that are controlled using Target code
try this as the first line
If Target.Count 1 Then Exit Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "NDBC" wrote in message ... I have columns that are set up to automatically respond when they contain the target cell. The code below all works fine. My problem is that when I finished I need to clear these cells. I am currently doing this by selecting a range and making it equal to "". This causes an error in the code below. Is there some way of disabling the target code when I delete the range. Thanks If Target.Column = 11 Then Target.Offset(0, 1) = WorksheetFunction.Max(Range("L:L")) + 1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting cells that are controlled using Target code
Don. Works a treat. Thanks again.
"Don Guillett" wrote: try this as the first line If Target.Count 1 Then Exit Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "NDBC" wrote in message ... I have columns that are set up to automatically respond when they contain the target cell. The code below all works fine. My problem is that when I finished I need to clear these cells. I am currently doing this by selecting a range and making it equal to "". This causes an error in the code below. Is there some way of disabling the target code when I delete the range. Thanks If Target.Column = 11 Then Target.Offset(0, 1) = WorksheetFunction.Max(Range("L:L")) + 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting row using vb code? | Excel Discussion (Misc queries) | |||
| VBA Code for Deleting a Row | Excel Worksheet Functions | |||
| ByVal Target Range Great Code but need Help | Excel Discussion (Misc queries) | |||
| retain hyperlink target when adding/deleting rows | New Users to Excel | |||
| Deleting Code from VBA | Excel Discussion (Misc queries) | |||
Linear Mode
