Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Insert
Is there a way to tell when a line insert occured. I do not see an
AfterInsert routine. Thank you, Steven. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Insert
You could probably find it with a worksheet_change event and look for
Target.Columns.Count = ME.Columns.Count -- HTH, Barb Reinhardt "Steven" wrote: Is there a way to tell when a line insert occured. I do not see an AfterInsert routine. Thank you, Steven. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Insert
I used the following within the Worksheet_Change event
If Target.Address = Target.EntireRow.Address then 'Row has been inserted or deleted End if |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
After Insert
Those are nice. Thank you. What I want to do is specifically catch the
insert. Is there a way do that? Thanks again. "Matthew Norman" wrote: I used the following within the Worksheet_Change event If Target.Address = Target.EntireRow.Address then 'Row has been inserted or deleted End if |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
Insert new Worksheet with name, and insert the sheet into itsalphabetical / numerical location | Excel Programming | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
Macro to insert copy and insert formulas only to next blank row | Excel Programming | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |