srgbs


Hi,

I have a master template which is copied to new sheet each my application is used for report generation, the newly created is renamed as per reporting period that end user specifies.

I now need to dynamically link the newly created sheet(report) to the summary sheet, i have tried different options but in vain :-(

sheets are not getting linked as sub address column only accepts address string (reference is not getting validated)

I have tried the following methods

Set ws = Worksheets(Index)

Set lnk = Worksheets(report)
ws.Hyperlinks.Add Anchor:=ws.Cells.Range("B13"), Address:="", SubAddress:= _
lnk!A1.Address, TextToDisplay:=reportname

Set ws = Worksheets(Index)

ws.Hyperlinks.Add Anchor:=ws.Cells.Range("B13"), Address:="", SubAddress:= _
Sheets(report)!A1, TextToDisplay:=reportname

Set ws = Worksheets(Index)

ws.Hyperlinks.Add Anchor:=ws.Cells.Range("B13"), Address:="", SubAddress:= _
"Worksheets(report)!A1", TextToDisplay:=reportname

Can anyone help me out on this please, if u require any further details do message back

Regards,

Guru.