Re: Identifying the type of a Worksheet_Change

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: tony h <tony.h.21s2dy_1137499201.7966@xxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 17 Jan 2006 05:57:28 -0600

the .target will not refer to anything when the row, cell or column has
been deleted. This is your indication that the structure has changed.

to test for this you can use
if .target is nothing then
'row/col deleted
else
'do your stuff
end if

--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21074
View this thread: http://www.excelforum.com/showthread.php?threadid=501980

.

Prev by Date: Re: Trim pace not necceesary
Next by Date: RE: looking for Excel programming help for project
Previous by thread: Copy paste code fails
Next by thread: RE: Identifying the type of a Worksheet_Change
Index(es):
- Date
- Thread

Relevant Pages

Re: How to find set of numbers to sum nearest to a given total but not more?
... Maybe you could try some of the other methods that you'll find if you do a Google search for "excel which values sum to target" or a similar search. ... "Tony" wrote in message ...
(microsoft.public.mac.office.excel)
Re: the SOPRANOS the next cliche ending for TV ?
... family killed at the same time, or did the hitmen that took Tony out ... stick to the classic Mafia code and only take out the target, ... Chase took the 'less is more' ditty to the extreme, where the same physics ...
(rec.arts.tv)
Re: the SOPRANOS the next cliche ending for TV ?
... stick to the classic Mafia code and only take out the target, ... Tony is as alive today as he ever was. ... When Tony awoke at the beginning of the finale episode, ... I am so done with plans. ...
(rec.arts.tv)
Re: the SOPRANOS the next cliche ending for TV ?
... stick to the classic Mafia code and only take out the target, ... Tony is as alive today as he ever was. ... Tony went to sleep with a gun in his arms in the next-to-last episode. ... When Tony awoke at the beginning of the finale episode, ...
(rec.arts.tv)
Re: the SOPRANOS the next cliche ending for TV ?
... stick to the classic Mafia code and only take out the target, ... Tony went to sleep with a gun in his arms in the next-to-last episode. ... When Tony awoke at the beginning of the finale episode, ...
(rec.arts.tv)