Hai Yudha,
Coba kode dalam prosedur diganti menjadi :
Dim rng As Range
Set rng =
Sheet2.Range("d19") 'set
range target mode statis
'Set rng = Sheet2.Range("d1").EntireColumn.Find("=Sum(",
LookIn:=xlFormulas) 'set range target mode dinamis, kriterianya formula
Sum
With Sheet1
.Range("a2").Value = rng.Value 'update nilai cell
'set hyperlinks : sub address ::> 'nama sheet'!cl54321
.Hyperlinks.Add Anchor:=.Range("a2"), Address:=vbNullString, _
SubAddress:="'" & rng.Parent.Name & "'!" &
rng.Address(False, False)
End With
Regards.
Kid.
2011/9/8 Yudha Saptiadi <[email protected]>
> **
>
>
> Para Pakar..
> mohon bantuannya makro yg saya buat ko ga bisa ngelink yaa, tolong di bantu
> yaaa..
>
> hatur nuhun...
>
> ys
>
>
>
>