CTRL-A + CRTRL-T using VBA

Hi there,

I would like to turn the a range of populated cells (the size of the range is supposed to change every time) into a table.
Manually I would do this by pressing CTRL-A first and CTRL-T then.

I want to create a macro for this and I tried with the script below.
However when it gets to the last line it returns "Run-time error '5':Invalid Prodecure call or argument".
Can somebody help me fix this issue? I attached a sample.
Thanks in advance for your help

Please Login or Register  to view this content.

Hi, if you would change this line into:

Please Login or Register  to view this content.

it will work
Cheers
Erwin