#NAME? error

I have created a macro that compares two rows and colors all differences in values for those two records/rows.
Basically the Excel sheet contains data from two Databases and the macro compares the 2 sets of records cell by cell.

For few cells I am having the content as "#NAME?" for which my macro throws an error while comparing. It is nt treating the cell data as a String. This is probebly bcoz the contents are like "=FGGFK" which Excel confuses a wrong function and replaces it with a "#NAME?".


Hw to resolve this .

Thanks
Ankur Kapoor

Hello Ankur Kapoor,

Here is a VBA macro code example of how to determine if a cell has an error, and then display the appropriate error message in a message dialog box.

Please Login or Register  to view this content.

Sincerely,
Leith Ross