macro giving #N/A error

**johncena** · 05-31-2010, 07:55 AM

Originally Posted by Andy Pope

Your data in Processing!D4 has a trailing space.

Therefore the lookup fails.

not clear for me sir,what i can do for this,,,,,,

**Andy Pope** · 05-31-2010, 08:05 AM

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.

**johncena** · 05-31-2010, 08:15 AM

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+

Re: macro giving #N/A error