Making range dynamic to Create Table

Hello

I am trying to create a table which will have all the data in a specific sheet included in it.

This is what I have so far and does work (mostly):

Please Login or Register  to view this content.

However the range will keep changing as more data is added. Please can someone confirm the code to make the range include everything in the sheet. There will never be more columns only more rows.

I tried making the range a larger number but that then includes the empty cells so is not an option.

Thank you for the help.

Does this help?

Please Login or Register  to view this content.

Hi jindon

I really do appreciate your quick responses.

Works perfectly - THANK YOU!

That will be very useful for a number of my other sheets!

You are welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

As well as your other thread.