cells(rows.count,1).End(xlup).ClearContents

--
Regards,
Tom Ogilvy

"CyndyG" wrote in message
...
How do I write the code to delete ascii character 127,that will always be
the
last entry in column A? Number of cells in column A will vary according
to
incoming data.