Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If Count is not in a certain range, delete Rows | Excel Discussion (Misc queries) | |||
Select a range of rows to delete | Excel Worksheet Functions | |||
delete rows in range - macro | Excel Worksheet Functions | |||
Delete Rows & Capture Range | Excel Programming | |||
Delete all Rows in a Variable Range | Excel Programming |