Lists

[SuitedAces]

I appreciate any help with this.

When right clicking on a range and converting it to a list ,is there a way to name the list at that point?

How can I manually copy a list from one workbook to another complete with the name ?

How can I copy a list from one workbook to another complete with the name through code?

How can I rename a list through code.



Thank you for your help.

[Leith Ross]

Hello SuitedAces,

When right clicking on a range and converting it to a list ,is there a way to name the list at that point?

The Excel doesn't provide an options for renaming the List.

How can I copy a list from one workbook to another complete with the name through code?

This applies to both copying questions.This is example shows the various ways to reference the list. The copy in this example is to another workbook. Remove the workbook name to copy somewhere else in the ssame workbook.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[SuitedAces]

Thank you for the help