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
|