LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default catch event insert a row or delete a row

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Catch column width event. Artem Omelianchuk Excel Programming 2 June 3rd 05 06:01 PM
How do I 'catch' a 'delete cells' event Eric Excel Discussion (Misc queries) 2 March 9th 05 07:22 PM
Catch drop event in excel Edi Excel Programming 1 February 20th 05 05:26 PM
Catch Update Linked Cells Event Joe[_23_] Excel Programming 1 August 14th 03 02:39 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"