Deleting Rows

M

matt_steer

I am trying to write a macro that will search in Column A for each cel
that contains a value ending in .01 (so i need wildcards) and the
delete the entire row.

Can anybody help
 
D

Don Guillett

You don't need wildcards if it always ends with .01
if right(cell,3)=".01" then cell.entirerow.delete
 
Top