Compile error in hidden module

[RAJESH1960]

Hello JohnnyL
The application Match Portal is running perfect in every way. Today I visited a new office and tested to run Match Portal application. But I ran into this error for the first time. What could be the reason and how do I rectify it to make it compatible to run in all versions of excel.?
Compile error in hidden module Match Portal
This error commonly occurs when code is incompatible with the version, platform or architecture of this application.

 

[johnnyL]

I would like to point out the 'add2' issue and the 'FormulaVersion:=xlReplaceFormula' issue were not my code.

 

[RAJESH1960]

I would like to point out the 'add2' issue and the 'FormulaVersion:=xlReplaceFormula' issue were not my code.

I know man. All the codes without comments ain't yours. The Add2 was edited by Domenic and I think he too was not aware that it would be used in older versions of excel.

 

[RAJESH1960]

After replacing Add2 with add and commenting the line JohnnyL suggested, the code ran without any problem in the old versions of excel. Tested and confirmed.
Thanks to JohnnyL and Fluff.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[johnnyL]

Congrats!

 

[johnnyL]

Duplicate

 

[RAJESH1960]

Congrats!

Congrats to you too.

 

[johnnyL]

Why me?

 

[johnnyL]

I didn't have to go in front of the other people, run the script, and when the error occurred say "Ummm, hold on folks, Let me log on to MrExcel real quick".

 

[RAJESH1960]

Ummm, hold on folks, Let me log on to MrExcel real quick"

True. I have no other option. When I have this forum where, when some think it is impossible to solve there are people who find a way to solve it, why should I worry.