Dear Mr. Toby,
Terima kasih atas masukannya, akan ane coba.
Salam,
DD
From: Toby kenzo tobyke...@yahoo.co.id [belajar-excel]
[mailto:belajar-excel@yahoogroups.com]
Sent: 20 April 2015 22:36
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Rekap Data dengan VBA
Dear Dede,
Coba buat module baru, masukan formula:
Sub Refresh()
Dim pvttbl As PivotTable
Dim ws As Worksheet
Sheet3.Activate
For Each ws In ActiveWorkbook.Worksheets
For Each pvttbl In ws.PivotTables
pvttbl.RefreshTable
Next
Next
End Sub
masukan Assign Macro pada Button Form Control ("Updat
2 matches
Mail list logo