Macro to run on multiple excel files find if any #N/A , #NAME?, #VALUE!

[JAVEDR]

Hello Sir/Madam,

I have multiple excel files in folder contains multiple sheets. I'm looking for macro to run on those and find if any #N/A , #NAME?, #VALUE!, #REF! and provide excel name if any contains this.

 

[mmhill]

In the pfSheetExists function, look for this line ...

pfSheetExists = (StrComp(TypeName(tmp), "String", vbTextCompare) = 0)

Change it to ...

pfSheetExists = (StrComp(TypeName(tmp), "Error", vbTextCompare) <> 0)

Then try it.

 

[JAVEDR]

In the pfSheetExists function, look for this line ...

pfSheetExists = (StrComp(TypeName(tmp), "String", vbTextCompare) = 0)

Change it to ...

pfSheetExists = (StrComp(TypeName(tmp), "Error", vbTextCompare) <> 0)

Then try it.

perfect thanks a lot now it works exact what i was looking for.

 

[mmhill]

Glad we got there