VBA to Dynamically list Worksheet Names

[MarkCBB]

Hi there,

I am looking for some VBA that can dynamically list all the names of the worksheets in a workbook (In Column A).
i.e. If I add a worksheet the name appears, if i edit the name the name is edited on the list and if I delete a worksheet the names is removed.

It doesn't need to be in order.

 

[JoeMo]

Is there a way I could attach the workbook here or send it to you?

Ygive you an emailou can't attach a workbook here. If you PM me I will give you an email address where you can send a copy of your workbook.

 

[BVavra]

Ygive you an emailou can't attach a workbook here. If you PM me I will give you an email address where you can send a copy of your workbook.

JoeMo has resolved the issue!! I cannot think you enough for your help.

 

[JoeMo]

JoeMo has resolved the issue!! I cannot think you enough for your help.

You are welcome - thanks for the reply.