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 |
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) |