Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
There was a recent post in this NG concerning this; can't find it now, but
Google Groups should help you. As Chip points out, no events will tell you when this happens, so you have to rely on something suitable; _Change or _SelectionChange. Create a single celled named way below any data/activity. Store its row in a variable. In a suitable event, check its row and see if it has changed; you tell how many up/down so how many rows inserted/deleted. NickHK "Nader" wrote in message ... Hello, I would like to catch the event when I add a row into a sheet or delete a row. So I could add or delete a row into another sheet at the same time. Is there an event on the row ? Is there another way to do that ? Thanks in advance Nader |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Catch column width event. | Excel Programming | |||
How do I 'catch' a 'delete cells' event | Excel Discussion (Misc queries) | |||
Catch drop event in excel | Excel Programming | |||
Catch Update Linked Cells Event | Excel Programming |