HI,
I have developed a bit of VBA code in the UK and have sent to someone in germany. They are getting type mismatch error and it is caused by the statement
Application.Evaluate(FC.Formula1)
where FC.Formula1 was quite a complex conditional format formula. I simplified the formula with:
Application.Evaluate("IF($J$27=0;FALSE;TRUE)=TRUE")
this again produced the same error. The formula works perfectly fine on the sheet and when i set my regional settings to UK. As soon as i change it to german i get the error message.
I also changed application to workbook which resulted in the same error message
do any of you guys know why this would be the case and could you point me in the right direction towards a solution.
Many thanks
I have developed a bit of VBA code in the UK and have sent to someone in germany. They are getting type mismatch error and it is caused by the statement
Application.Evaluate(FC.Formula1)
where FC.Formula1 was quite a complex conditional format formula. I simplified the formula with:
Application.Evaluate("IF($J$27=0;FALSE;TRUE)=TRUE")
this again produced the same error. The formula works perfectly fine on the sheet and when i set my regional settings to UK. As soon as i change it to german i get the error message.
I also changed application to workbook which resulted in the same error message
do any of you guys know why this would be the case and could you point me in the right direction towards a solution.
Many thanks