| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting when Excel user inserts or deletes a row
I want to know when an Excel user either deletes or inserts a row so that I
can modify other cells to reflect the loss (or gain) of the row. Is there an event that occurs (like in Worksheet_Change) that I can inspect to see what they have done? Thanks in advance. Warren |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting when Excel user inserts or deletes a row
Hi W,
This is an often asked question, but no such event is exposed. --- Regards, Norman "wjewell" wrote in message ... I want to know when an Excel user either deletes or inserts a row so that I can modify other cells to reflect the loss (or gain) of the row. Is there an event that occurs (like in Worksheet_Change) that I can inspect to see what they have done? Thanks in advance. Warren |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting when Excel user inserts or deletes a row
Create a range name eg rLastRow - in the last row on the test. Test the row
value of the rLastRow on a selection change event. If it differs from previous value that you saved then your procedure can run. "Norman Jones" wrote: Hi W, This is an often asked question, but no such event is exposed. --- Regards, Norman "wjewell" wrote in message ... I want to know when an Excel user either deletes or inserts a row so that I can modify other cells to reflect the loss (or gain) of the row. Is there an event that occurs (like in Worksheet_Change) that I can inspect to see what they have done? Thanks in advance. Warren |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Detecting when Excel user inserts or deletes a row
Another way is to place a formula somewhere in the worksheet that refers to a
whole column like =COUNT(A:A). Now, whenever a row is inserted or deleted, the Worksheet_Calculate event will fire. Regards, Vic Eldridge "reuben" wrote: Create a range name eg rLastRow - in the last row on the test. Test the row value of the rLastRow on a selection change event. If it differs from previous value that you saved then your procedure can run. "Norman Jones" wrote: Hi W, This is an often asked question, but no such event is exposed. --- Regards, Norman "wjewell" wrote in message ... I want to know when an Excel user either deletes or inserts a row so that I can modify other cells to reflect the loss (or gain) of the row. Is there an event that occurs (like in Worksheet_Change) that I can inspect to see what they have done? Thanks in advance. Warren |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Detecting when a user deletes a row | Excel Programming | |||
| Detecting when a user deletes a row | Excel Worksheet Functions | |||
| Detecting user idle time | Excel Programming | |||
| Detecting when user deselects an add-in | Excel Programming | |||
| Detecting Input Change on User Form | Excel Programming | |||
Linear Mode
