I tried it here too, also in Excel 2003.... Try..You're sort of right... Some don't work..Sub subName(P1)Sub subName(P1 as variant)... Didn't workSub subName( p1 as string )DidI will be interested to see if it works there as well.