| 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 | |||
Linear Mode
