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 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?