Remove Hard Carriage Return And Leading And Trailing Spaces

[Excel Fox]

That seems to be a completely different requirement, unrelated to what you are doing above. Best to start a new thread with the code/sample workbook

[David Montoya]

I have resolved the issue of the conditional formatting by modifying the target.

Regarding the solution for the trim and carriage returns' removal, which work very efficiently, I am still running into a problem. My worksheet contains several other macros; one of the macros is to append the worked data to a different worksheet, and I am getting at the column "A" of the worksheet where I am applying your solution multiple rows with "#VALUE!" which when doing the append, it gives me incorrect results due to the contents of column "A".

I am wondering if possible to have your solution, instead of hard coded for a range, to have it dynamically to be triggered by an input to a cell of the column "A", and within the range "A4:A1004"

Thank you!

[DocAElstein]

Hello David Montoya,
I am finding it hard to understand what you are asking with this:

I am wondering if possible to have your solution, instead of hard coded for a range, to have it dynamically to be triggered by an input to a cell of the column "A", and within the range "A4:A1004"

As I understand it, the effect of this code line, .._

  If Not Intersect(Target, Range("A4:A1004")) Is Nothing Then

_.. , is to trigger, if a cell or cells in the range "A4:A1004" have its or their value changed.

( Further, the effect of this, .._

    With Intersect(Target, Range("A4:A1004"))

, _.. is to restrict action to the cell or cells which were changed. )

That sounds close to what you are asking for.
So I am confused about what you are actually wanting.
It does not take much to coinfuse me. So I may have overlooked something, or missed the point
It might be easier if you could give us a workbook with a reduced size sample, of desensitized data, to help explain what you want and / or what the problem is that you are having.

Alan

P.s. Welcome to excelfox.com :-)