A quick way to get rid of every other row is to add an extra row and
fill down this row with 1 and 2 alternately, then filter to show either
the 1's or 2's and select the filtered rows and delete them


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=546975