Delete a range of rows ?
- From: "SpookiePower" <boxjunk2600@xxxxxxxxx>
- Date: Tue, 24 Jan 2006 15:42:35 +0100
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
.
- Follow-Ups:
- Re: Delete a range of rows ?
- From: Tom Ogilvy
- Re: Delete a range of rows ?
- Prev by Date: Re: Save to hard drive and backup to thumb drive.
- Next by Date: Re: Not enough memory ,message
- Previous by thread: Re: Simple VB code
- Next by thread: Re: Delete a range of rows ?
- Index(es):