I'm struggling with this one and am thinking that I'm close but setting up something incorrectly. Basically I build detail pages with customer information and on a main page summarize the data. For ease of use I'd like to set up a link to the other pages in column A. The .NET code that I have does place the link in the column but when I look at the address in the link I'm getting something like this: 'Pg%201'!$A$1
I'm intrigued by this as the value that I'm placing in my code is 'Pg 1'!$A$1
My code:
mainSheet.Hyperlinks.Add(mainRange.Offset(0, -1), "'" & sheetName & "'" & "!" & currRange.Address.ToString, , , CType(pg + 1, String))
Suggestions?
I always makes things much harder than they should be... that way later I can slap myself in the forhead after spending hours and hours on two lines of code and say to myself "DUH!"
I'm intrigued by this as the value that I'm placing in my code is 'Pg 1'!$A$1
My code:
mainSheet.Hyperlinks.Add(mainRange.Offset(0, -1), "'" & sheetName & "'" & "!" & currRange.Address.ToString, , , CType(pg + 1, String))
Suggestions?
I always makes things much harder than they should be... that way later I can slap myself in the forhead after spending hours and hours on two lines of code and say to myself "DUH!"