View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default Removing every other line

Try this:

Just one rule:
Cells A9 through A11 must contain any kind of value

A1: MyCriteria
A2: =ISEVEN(ROW(A10))

Data|Filter|Advanced Filter
List Range: (select from A9 down as far as you need)
Criteria Range: (Select A1:A2)
Click the [OK] button

The filter will only display even numbered rows under A9
Select the filtered rows under A9

Edit|Delete (Excel will only allow you to delete entire rows when a filter
is engaged)

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Sawyer" wrote:

Hello All
I need a script to remove every other line in a excel document, starting at
say line 10 and delete line 11,13,15 and so on is this something that can be
done.
Thanks for any help
Scott