Thanks Paul,
Works wonderfully....and much more sophisticated than my solution. One more small problem...although I said I only had 4 tables, there are actually 6, but I only want the macro to edit the first 4. How to control this programmatically...thats why I thought I could use the table index....or was my intent.

thanks
dale