VBA with excel

[davetek]

Hi,
i need to to delete rows in excel based on conditions on a certain row.....i.e. delete all rows where 'X' is in col A
any suggestions??

 

[xlbo]

Try this
Sub delRows()
for i = Range("A65536&quot.end(xlup).row to 2 step -1
if range("A" & i).text = "a" then
rows(i & ":" & i).entirerow.delete
else
end if
next i
end sub Rgds
~Geoff~