On 25 Aug, 17:25, DCG-jaeson wrote:
Team,

How can I automatically use the Worksheets name in to a Dropdown list
(Validation). Can I just make it with a excel formula or need a Macro?

I were using Excel 2000.

Thanks in advance,
~jaeson

A macro would be required - here is a stub:

Sub List_Worksheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
Debug.Print ws.Name
' add to your data validation list here
Next ws
End Sub