Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Row Event
You could insert a command button or button on custom toolbar that would
trigger a sub to insert a column into both worksheets at the same time. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Before Worksheet Insert Event | Excel Programming | |||
Sheet Change Event (Insert Row) | Excel Programming | |||
Sheet Insert Row Event? | Excel Programming | |||
Insert Row (Event Classification) | Excel Discussion (Misc queries) | |||
catch event insert a row or delete a row | Excel Programming |