This has been dealt with before. A simple forum search could have turned up:
http://www.vbaexpress.com/forum/show...to-Excel-Table
http://www.vbaexpress.com/forum/show...l=1#post257696
and, further down in the same thread:
http://www.vbaexpress.com/forum/show...l=1#post291047