REPOST: Find a row and delete it
Hi,
Oops, you're right of course.
In that case, I see little improvement opportunities,
short of using the MATCH worksheet function to quickly
find the first match and act accordingly. It would
probably beat looping through the rows.
Regards,
Jan Karel Pieterse
Excel TA/MVP
-----Original Message-----
Hi Jan. He would though end up deleting all rows that
contained his criteria, and not as I think
he is suggesting, delete only the first instance of the
criteria. (Assuming he has articulated
his problem correctly of course)
--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL2K & XLXP
----------------------------------------------------------
------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------
------------------
"Jan Karel Pieterse" wrote in
message
...
Hi,
You may find it better to do the search up-side-down,
otherwise you might miss out rows.
Also, it may be far more efficient to use excel's
autofilter method to first filter the rows using your
del
criteria. Then delete the visible rows all in one go.
You might record a macro setting up the autofilter, then
pressing F5 (goto), special, visible cells only, then
doing the deletion. Then edit the recorded (bad) code to
generalise.
Regards,
<snip
.
|