macro giving #N/A error

Originally Posted by Andy Pope

remove the trailing space from the cell.

In a spare column you could use the formula =TRIM(D4)
then copy+paste special values back over D4.

wow thanks a lot sir it's work.REP+