delete 1 line after each 65 lines

**dprins** · 01-13-2010, 05:13 AM

I have 2 columns in Excel wich havn't the same amount of lines.
One colom is 65.000 lines and the other one is 64.000
I am looking for a option to delete 1 line after each 65 lines.
Is this possible?

(Yes, I know my English is bad

)

**pike** · 01-13-2010, 06:28 AM

Hi dprins
try....

PHP Code:


For x = 66 To Cells(Rows.Count, 1).End(xlUp).Row Step 65

   Cells(x , "A").entirerow.Delete Shift:=xlUp

  Next

Edit comment below

**contaminated** · 01-13-2010, 06:40 AM

This is actually can be done with VBA. You should have posted this thread in Excel Programming thiugh

You didn't mentione where deletion must be performed in. So I assumend that is Column A.

Please Login or Register  to view this content.

**dprins** · 01-13-2010, 07:41 AM

It worked. Thank you!!!

**pike** · 01-13-2010, 07:51 AM

Dont forget

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

**dprins** · 01-13-2010, 08:07 AM

I didn't know how to set the post to solved, I tried but I couldn't find it.
thanks again

**mbenazeraf** · 01-17-2010, 12:20 PM

Thanks all. I will try Pike's and JB's suggestions and will return to the post.
Great board. This my first try on it.
Question: Why is it when I print this page, the macros under the heading "code" are printed in light grey color? Very hard to read. Any suggestion how to improce that?
Thanks.