Formatting wipe out

[rr1050]

Hello there,

Sometime after a copy paste, formatting still exits and I need to wipe out that empty cell formatting from given column.

Anyway to do it by VBA, so I will add that lines in code.

Regards, RR

[Rick Rothstein]

This single line of code should do what you want...

Please Login or Register  to view this content.

[rr1050]

Nice, it work well... Thanks