macro does not sheet name
 

"Todd" wrote:

Hi,


Range("C7").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"'12010'!A61", TextToDisplay:="January"

Never worked with hyperlinks, but I think what you want to do is change SubAddress to:

SubAddress:= "'' & activesheet.name & "'A61"

not 100% sure of the syntax, but if VBA acts like the INDIRECT function, this should work.

macro does not sheet name
 

Actually, it should be this:

SubAddress:=ActiveSheet.Name & "!A61"

macro does not sheet name
 

Thank you! The second way is working.

"Marcotte A" wrote:

Actually, it should be this:

SubAddress:=ActiveSheet.Name & "!A61"