Delete a range of rows ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


I made this code to delete a range of rows, but I found out
that this code only delete every second row.

Do Until Worksheets("Materielplacering").Cells(lCurrentRow, 4).Value = ""
Worksheets("Materielplacering").Rows(lCurrentRow).Delete
lCurrentRow = lCurrentRow + 1
Loop

I need to delete some rows, starting from row X to Y
It must be possible to make it like Range.(X,Y).delete
or something like that, but I'm not sure how to write
this single line of code.






--
Mit fotoalbum
www.photo.activewebsite.dk


.

Relevant Pages

  • Re: Finding the execution time
    ... for i in 1 to M loop--start from the second row ... end loop; ... in RAM to make it synthesizable? ... Prev by Date: ...
    (comp.lang.vhdl)
  • Until end of array ?
    ... I have this array ArrayTextBoxMaterieland I use this code to run through the array - ... Loop ... Mit fotoalbum ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: processing a sequence
    ... (loop for sublist = (collect-sublist) ... return accum if not element = list.first ... if prev and element < prev ... James still didn?t show his Ruby one-liner that outperforms the Lisp ...
    (comp.lang.lisp)
  • Re: Process notification
    ... As you see from prev. ... posts there is no obsolute user mode solution on how ... and then immidiatly terminated - your "monitoring loop" may not detect it. ... Vladimir ...
    (microsoft.public.win32.programmer.kernel)
  • RE: Extreme beginner question on reading lines from a file.
    ... print FILEOUT "M98PPECK.SUBL1\n"; ... the 1st line is written into $prev. ... This code will fail if there's ... If it fails it returns false and the loop exits. ...
    (perl.beginners)