| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
detecting row or column insertion & deletion
Arun,
No, there is no way native to Excel to determine when a column or row has been added or deleted. There are as many ways around this as there are VBA experts: my last post shows a solution that works. You can use the SheetChange event as well - BUT you STILL need a way to determine if the row or column was added or deleted. HTH, Bernie MS Excel MVP Well isnt it even possible to use some property or state of the range or worksheet object returned with the SheetChange event to recognize that this is what has happened ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto column insertion based on a number | Excel Worksheet Functions | |||
| Selective Column deletion | Excel Discussion (Misc queries) | |||
| Detecting Row Deletion | Excel Programming | |||
| Detecting Row Deletion | Excel Programming | |||
| Class module to detect row deletion or insertion ? | Excel Programming | |||
Hybrid Mode
