>
> Thanks
> So how do you recommend supporting both regions without duplicating
> macros.
>
> *** Sent via Developersdex http://www.developersdex.com ***

Ken

This might help you to decide which formula to parse

activeworkbook.application.International(xlListSeparator)

It will give a ";" for NL and a "," for US

This one will work I guess and avoid duplication

y = Array("hello", "=if(x" &
activeworkbook.application.International(xlListSeparator) & "0" &
activeworkbook.application.International(xlListSeparator) & "0)")

Cheers,
Erik