Why?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mike H" wrote in message
...
I bet you meant

For j = 24 To 1 step -1

Mike

"Bernard Liengme" wrote:

You gave us spare detail but here is a subroutine that deletes a row when
the value in column H (the 8th column) has a value less than 10. It does
this for rows 1 to 24.

Sub tryme()
For j = 1 To 24
If Cells(j, 8) < 10 Then
Cells(j, 8).EntireRow.Delete
End If
Next j
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Aceensor" wrote in message
...
I have been away from writing macros for a while now, so any help would
be
greatly appreciated. I'm attempting to write a simple macro to delete
lines
in a spreadsheet based on cell values in a particular row / column. I
know
it's simple but again, it's been awhile!

Thanks in advance!