Delete ascii character 127
 

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.

Delete ascii character 127
 

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.

Delete ascii character 127
 

Thank You
"Tom Ogilvy" wrote:

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.