Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to delete a series of rows from a spreadsheet using the following
code. Public Sub DeleteRows() Dim i As Integer Do Until i = 500 With ActiveCell If ActiveCell.Value = Nul Then .EntireRow.Select Selection.Delete (Cells(1, 0)).Select End If End With Selection(0).End(xlDown)(2).Select Loop End Sub Once the row has been deleted I do not know how to move the selected cell down three rows to the next range to be selected. Can anyone help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting Blank Rows | New Users to Excel | |||
Deleting blank rows | Excel Programming | |||
DELETING BLANK ROWS | Excel Programming | |||
deleting blank rows | Excel Programming | |||
Deleting Blank Rows | Excel Programming |