Re: Fw: Re: [belajar-excel] hi

2009-03-03 Terurut Topik setyoDevi
rom: siti Vi > Subject: Re: Fw: Re: [belajar-excel] hi > To: belajar-excel@yahoogroups.com > Date: Tuesday, March 3, 2009, 12:12 AM > > sekali lagi mas t0f1q.. > analisis, evaluasi, lalu memberikan komentar / saran mauk-pun "pencerahan" > hanya akan bisa dilaksanakan jika

Re: Fw: Re: [belajar-excel] hi

2009-03-03 Terurut Topik Taufiq Baba
alo mbak, udah gak jadi, gua yang salah, lupa masukin "on error resume next" he he he --- On Tue, 3/3/09, siti Vi wrote: From: siti Vi Subject: Re: Fw: Re: [belajar-excel] hi To: belajar-excel@yahoogroups.com Date: Tuesday, March 3, 2009, 12:12 AM sekal

Re: Fw: Re: [belajar-excel] hi

2009-03-02 Terurut Topik siti Vi
gt; > --- On Sat, 2/28/09, siti Vi wrote: > > From: siti Vi > Subject: Re: Fw: Re: [belajar-excel] hi > To: belajar-excel@yahoogroups.com > Date: Saturday, February 28, 2009, 2:46 AM > > Yup; itu betchul... pak.. > biar ngebut gitu loch... > > Mengenai calculation,

Re: Fw: Re: [belajar-excel] hi

2009-03-02 Terurut Topik Taufiq Baba
Vi wrote: From: siti Vi Subject: Re: Fw: Re: [belajar-excel] hi To: belajar-excel@yahoogroups.com Date: Saturday, February 28, 2009, 2:46 AM Yup; itu betchul... pak.. biar ngebut gitu loch... Mengenai calculation, terutama jika di sheets banyak rumus berat, akan

Re: Fw: Re: [belajar-excel] hi

2009-02-27 Terurut Topik siti Vi
Yup; itu betchul... pak.. biar ngebut gitu loch... Mengenai calculation, terutama jika di sheets banyak rumus berat, akan terasa bedanya, karena pada saat cells diubah datanya proses calculating disuruh istirohat dulu... terima kasih On 2/27/09, Slamet Harto wrote: > > cuma nambahin dikit

Re: Fw: Re: [belajar-excel] hi

2009-02-27 Terurut Topik Slamet Harto
cuma nambahin dikit vbanya mba Siti untuk mempercepat proses sebelum proses loop awal dimulai bisa ditambahkan: with Application .ScreenUpdating = False .Calculation = xlCalculationManual end with lalu pada baris setelah loop berakhir atau setelah next terakhir with Application .ScreenUpda

Re: Fw: Re: [belajar-excel] hi

2009-02-26 Terurut Topik siti Vi
modifikasi dikittt... hanya di baris yg siti beri font warna merah Sub FilterNonBlank() ' siti Vi memfilter tabel ' jika kolom_3 = kosong: record di ignored Dim Tabel As Range, TbArr() Dim n As Long, r As Long, c As Integer On Error Resume Next Set Tabel = Application.InputBox(

Fw: Re: [belajar-excel] hi

2009-02-23 Terurut Topik Taufiq Baba
He he he iya nih saya kasih contoh kasusnya, mohon bantuan master ya.. --- On Sun, 2/22/09, siti Vi wrote: From: siti Vi Subject: Re: [belajar-excel] hi To: belajar-excel@yahoogroups.com Date: Sunday, February 22, 2009, 5:08 AM hallo mas t0f1q kalau bisa sebaiknya con