Excel VBA Help

Stelly · 12 Jul 2013 at 12:06

Hey Guys,

Head is mashed at the moment and the misses need some VBA for a worksheet... so I have this:

For Each c In Worksheets("Master").Range("A2:A100").Cells

I want to create a hyperlink for each sheet that's being dynamically created by me so the name of the sheet is c.Name

Any help constructing the VBA for the hyperlink would be appreciated

Cheers,

Stelly

Stelly · 12 Jul 2013 at 13:29

Hey guys,

This seems to add the hyperlink but not to the correct sheet!

c.Hyperlinks.Add Anchor:=Range(c.Address), Address:="'" & c.Text & "'!A1", TextToDisplay:=c.Text

Stelly

Stelly · 12 Jul 2013 at 13:48

never mind sorted it

Stelly

monkehhh · 12 Jul 2013 at 13:50

Change Range(c.Address) to Worksheets("Master").Range(c.Address) ?

Edit - too slow