Delete ascii character 127

[Guest]

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.

 

[Tom Ogilvy]

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

 

[Guest]

Thank You

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