would edit replace 39079 with nothing work?

--
Don Guillett
SalesAid Software

"Mir Khan" wrote in message
...
I have to deal with a worksheet on the daily basis and column A of this
file
looks like this:

Agent Login & Name: 4001 - Erick Kiersnowski
39079
Agent Login & Name: 4002 - Katie Wilhelm
39079
**
Agent Login & Name: 4003 - Henry Arcalas
39079
39079
Agent Login & Name: 4006 - Manuel Prospero
39079
Agent Login & Name: 4010 - Camille Capatayan
39079
39079
Agent Login & Name: 4011 - Sandra Martinez
39079
**
Agent Login & Name: 4014 - Pete Garcia
39079
39079
Agent Login & Name: 4015 - April Solidum
39079
**
Agent Login & Name: 4018 - Michael Butson
39079
39079

The number 39079 gets incremented by 1 everyday, i need a macro to delete
this number without deleting the entire row?