Resize table based on Cell value

I am trying to resize a table based on the value entered in a cell. I am using the code below and it works to resize but the number of rows is wrong. It errors if I enter 1 or 2, 3 or 4 sizes it to 1 row, 5 does 2 rows, 6 does three rows and so on - not sure what is going on.

Please Login or Register  to view this content.

Maybe?

Please Login or Register  to view this content.

That gives me a type mismatch error on:

Please Login or Register  to view this content.

That gives me a type mismatch error on:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Still a type mismatch error.

Try:

Please Login or Register  to view this content.

Can you attach your workbook, with some sample data?

Here is my excel document that I am working on.

This code works, but it does not create the correct number of rows:

Please Login or Register  to view this content.

I was able to get it to work with the code below:

Please Login or Register  to view this content.