line delete interception

Hi from Paris (France)

I want to save a specified data (cell in colonne A:A) of a line to be
deleted, before suppression.
How can intercept the line delete event ?


Thanks by anticipation,

Hi,

The row delete fires the 'Worksheet_Change' event ... but so do lots of
things.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"[email protected]" wrote:

> Hi from Paris (France)
>
> I want to save a specified data (cell in colonne A:A) of a line to be
> deleted, before suppression.
> How can intercept the line delete event ?
>
>
> Thanks by anticipation,
>
>

Thanks Chris for the suggestion,
Is there any way to detect deleted line , previously its deletion ?

Hi,

Unfortunately the Target range returned in Worksheet_Change refers to the
new row (i.e. the one that was below what you have deleted).

I looked at something like;

If Target.Rows.Count = 1 And Target.Columns.Count = 256 Then

Application.Undo

'Save the details down here

Application.Repeat

End If

But I don't think there is the sophistication in the worksheet events to
capture this. I've looked at Application.Undo ... but does not seem to meet
the need. I think you would need to set up your own 'delete row' macro & have
users use that macro.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"[email protected]" wrote:

> Thanks Chris for the suggestion,
> Is there any way to detect deleted line , previously its deletion ?
>
>

Unfortunately, there is no way to detect when a user deletes a
row.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


<[email protected]> wrote in message
news:[email protected]...
> Hi from Paris (France)
>
> I want to save a specified data (cell in colonne A:A) of a line
> to be
> deleted, before suppression.
> How can intercept the line delete event ?
>
>
> Thanks by anticipation,
>

Thanks for your help, Chris and Chip.

May be in the next Excel version ?