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

