Row addition capture

[sunny.mohar]

How to know if a new row or column has been
added to sheet.I want to run a macro,when
a new row has been added to worksheet ,manually .

Thanks in advance.
This message was edited by sunny.mohar on 2002-03-11 16:19

 

[Juan Pablo González]

Well, i worked this out, kind of. First, you need to put it in the _Calculate() event. Name a cell, at the bottom of your range (Assuming you have one...). Then, in your macro, you can "look" at this range row with:

Range("MyRange").Row

and compare it with your "standard", that way you can tell if a row has been added.