niewbe me... never mind I figured t out!
thank you!
"Ron de Bruin" wrote:
Hi Steven
Start here
http://www.rondebruin.nl/delete.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"steven" wrote in message ...
hi sorry for being a pain...
I have a worksheet with data from column A to E and from rows 1 to (lets
say) 5000. I want a macro that serches for rows that have "2" in column C and
are NOT BLANK, then select all thses rows from column A to IV (not just A to
E) and then delete them (shiftng all other rows up but i think this happens
automatically. How can I do this.
Also in the resulting table I want to select all remaianing rows (again from
A to IV).
thank you.