Is this a Duh! or what?I use this a lot. I though so and I just verified. MID is a $tringfunction... It is MID$( then you should get the auto complete.Excel 2002 VB 6.3 on Win XP