Row addition capture

sunny.mohar · Mar 11th, 2002, 05:08 PM

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 · Mar 11th, 2002, 05:21 PM

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.

Mar 11th, 2002, 05:21 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	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. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 05:08 PM	#1
sunny.mohar New Member Join Date: Mar 2002 Posts: 3	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 ]