Jim, you are a star! Thank you so much, I would never have worked that one
out. It worked a treat, on my system at least. Now to send the modified
worksheet over to my French colleagues to see if it still works.

JR

"JadeGolem" wrote:


I have been researching a different problem with localization but I came
across a possible solution for yours. Try using a semi-colon (; )
instead of a comma (,) in the list of cells for the Range. i.e.
ActiveSheet.Range("E3;K3;K5;M3;E5;I8;E4;K4;D8;M8;N 26;N27;N28;N31;N32;N33").Cells

This should work for most European locales (AFAIK) but you will still
need to figure out how to determine the users locale and then set the
separator as either comma or semi-colon based on the locale.

hth,
Jim


--
JadeGolem
------------------------------------------------------------------------
JadeGolem's Profile: http://www.thecodecage.com/forumz/member.php?userid=845
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=131701