The reason is because you only recorded a macro. So it wants to delete
the exact same rows as you deleted when recording. If you post your
"criteria" to determine if a row is to be deleted, it might be easier
for someone to help you out. To answer your first question though, it
is possible.

rhjaisingh said:
<
<Conditional Delete in Excel using Macro
<Hello all,
<Is it possible to creata an AUTO_OPEN such that all rows in the
<spread-sheet which satisfy a certain criterir get deleted ? The data
is
<obviously dynamic. When I used the AUTO_OPEN and created a macro
which
<deleted the rows (I was manually doing the process and recording the
<macro), if the data did not change, it worked fine. If I changed the
<data, as in added or removed rows that fulfilled the criteria for
<deletion, the thing went haywire - I realized - the deletion was
<working only on a range and if the data changed, the range changed,
and
<this got messed up. Any help ?
<Thanks much.


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=536595