ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting cell value (https://www.excelbanter.com/excel-programming/380930-re-deleting-cell-value.html)

Don Guillett

Deleting cell value
 
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?












All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com