View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Insert Row Event

The only way you can do it is to compare the number of rows og data on each
sheet to determine when they don't match. You also need some column that has
unique values in each row (line an ID number) so you can determine where the
new row was added or deleted.

"miroslj" wrote:

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.