Hi
I dont know much about VBA but one suggestion is for u to turn macro recording on and create a table manually..then edit the code and see how it does it.
Regards
Stuart