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

Kirim email ke