Thanks Mr Kid

Sudah seseuai dengan kebutuhan.

Regards,
Yudha

On Thu, Sep 8, 2011 at 8:08 AM, Mr. Kid <[email protected]> wrote:

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