Deleting Rows
 

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

--
Message posted from http://www.ExcelForum.com

Deleting Rows
 

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

--
Don Guillett
SalesAid Software

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

Can anybody help?


---
Message posted from http://www.ExcelForum.com/