Create worksheet from list with hyperlink

[HelpNeeded2023]

Hi,
I know this has been answered a million times before, but how do I create worksheets from a list with a hyperlink.

I have an old macro that work in an old workbook, but I must be doing something wrong or I've set it up incorrectly in a new workbook, as I get an error.

Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range

Set MyRange = Sheets("Job List").Range("B3201")
Set MyRange = Range(MyRange, MyRange.End(xlDown))

For Each MyCell In MyRange
Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
Next MyCell
End Sub

Thanks in advance.

 

[My Aswer Is This]

You said:
"I know this has been answered a million times before, but how do I create worksheets from a list with a hyperlink."
I see nothing in your script that refers to a hyperlink.