Need help with macro

  CalebBoro 06:54 01 Dec 2014
Locked

Need help in figuring out a better way to hyperlink excel spread sheet cells. Need to go to cell A501 with break in some of the cells along the way because they are blank. I started on A2 and then thought there had to be a better way. Here is some of the Macro I have:

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "Assessments!A28" Range("A28").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "Assessments!A28" Range("A29").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "Assessments!A29" Range("A30").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _ "Assessments!A30"

  Forum Editor 12:54 01 Dec 2014

You might find that you get a better response to this query if I move your thread to our Tech Helproom section - there are some real Excel experts there.

Email me if you're OK with that ([email protected]). I won't do anything unless I hear from you.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 6 review

Razer's Core X GPU enclosure hands on review: It's cheaper, bigger, and even works with Macs

MacBook Pro keyboard issues and other problems

E3 2018 : dates, conférences de presse, billets et plus