overflow error

[shayk1985]

hi,
when i am running tests i m getting errors like overflow error.
why this error occurs. it is occuring where i have taken phone numbers. for phone numbers i used right, left, mid. where ever i used them i get this occur with error code 13 and also i get error code 6 for this saying type mismatch.
please help

[elango87]

Are you using an array to store the values?

[pradeep singh]

Hi,

I think there would be error related to data type.As phone no. is long ,so instead of using int ,use long (clng) datatype.
Let me know ,is this solve your error otherwise show me your code.