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 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 ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks