Dynamic Named Range instead of Table for data transfer to userform listbox

Hello,
I'm trying to transfer the full data content of a worksheet to a userform listbox by keeping the format as it is on the worksheet.
When the data is converted into table, then I managed to do it with the following code.

Please Login or Register  to view this content.

Would it be possible to get the same end result but by using a dynamic named range instead? - That is because the data itself will be created through another userform to which it will look for the last non empty row and paste new entry in the next row. However, when the data is formatted to table, it will consider the table as a non-empty row so therefore paste only new entry next to the very end of the table.

Thank you for your help.

Solo

Hello solo,

Try something like...

Please Login or Register  to view this content.

Change "MyNamedRange" to the name of your named range.

Hello solo,

You need to use the named range again like this...

Please Login or Register  to view this content.

You can also assign it to an object variable to make it easier to read...

Please Login or Register  to view this content.