LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Insert Row Event

I need to catch when the new Rows are inserted or existing rows are Deleted
into the Sheet1.
And When this happed to insert the new Rows in Sheet2
at the same position (with the same row number).

But all that I find is event Worksheet_Change,
and I can not make difference using this event if
the new Rows are inserted or existing rows are Deleted
OR just Copy(rows) command.

 
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
Before Worksheet Insert Event Excel Monkey[_2_] Excel Programming 0 April 14th 09 08:59 PM
Sheet Change Event (Insert Row) WCM Excel Programming 2 July 24th 07 11:46 PM
Sheet Insert Row Event? WCM Excel Programming 1 July 24th 07 08:26 AM
Insert Row (Event Classification) WCM Excel Discussion (Misc queries) 3 June 11th 07 01:34 PM
catch event insert a row or delete a row Nader Excel Programming 2 July 21st 06 06:38 AM


All times are GMT +1. The time now is 03:34 AM.

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"