any variable would do. I use iloc out of habit. i for integer (although I
would probably dim them as Long), Loc for location (location in the string)

the U was for USD
the E was for EUR

In summary, no special significance for ilocE or iLocU

If you mean what do they do, then the Instr function returns the location in
the string where the substring is found. If not found, it returns zero. So
ilocU and ilocE just store the result of instr.

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy



"ina" wrote:

Thanks you a lot.

Could you explain me why ilocU and ilocE. I am newbie in VBA :)

Ina