View Single Post
  #4   Report Post  
Alan Beban
 
Posts: n/a
Default

Darren wrote:
I have a rather large document where I need to delete every other line
beginning with line 8. I am looking for a shortcut rather than manually
deleting each line.


If the functions in the freely downloadable file at
http://home.pacbell.net are available to your workbook, then assuming
your data is on Sheet1 in Columns A:K

Array enter into A1:K7 of an empty sheet =Sheet1!A1:K7

and array enter into A8:A[whatever] of that sheet
=ArrayAlternates(Sheet1!A8:K[whatever],False)

Alan Beban