Re: [belajar-excel] Placed Result

2010-02-22 Terurut Topik Mr. Kid
r supaya bisa copy paste values seluruh range target Kid. On Mon, Feb 22, 2010 at 3:39 PM, siti Vi wrote: > > >  > karena > (mungkin) mas Kid belum menujukan prosedur tsb untuk > tabel result yg baru (yg sudah diberi sisipan dua bari SUM ) > -- > > - Original Mess

Re: [belajar-excel] Placed Result

2010-02-22 Terurut Topik siti Vi
, February 22, 2010 3:10 PM Subject: Re: [belajar-excel] Placed Result Di komputah q hasil SUM nya koq ellol yach!??! Wassalam. ...zhot thea On Mon, 22 Feb 2010 14:20:42 +0700, Mr. Kid wrote: sudah selesai ya kasusnya kok panjang banget, kayanya pada asik.. yang ini tanpa loop sendiri (biar excel

Re: [belajar-excel] Placed Result

2010-02-21 Terurut Topik Mr. Kid
ry recommended tuk dipelajari! > > > Salam, > > anton suryadi > > > > -- > *From:* siti Vi > > *To:* belajar-excel@yahoogroups.com > *Sent:* Mon, February 22, 2010 9:45:43 AM > > *Subject:* Re: [belajar-excel] Placed Result

Re: [belajar-excel] Placed Result

2010-02-21 Terurut Topik anton suryadi
on suryadi From: siti Vi To: belajar-excel@yahoogroups.com Sent: Mon, February 22, 2010 9:45:43 AM Subject: Re: [belajar-excel] Placed Result  j - nya pak anton itu kan sama dengan AKUM nya siti yaitu variable untuk mengakumulasi- kan data bilangan s

Re: [belajar-excel] Placed Result

2010-02-21 Terurut Topik siti Vi
, February 22, 2010 9:35 AM Subject: Re: [belajar-excel] Placed Result Oiah sorry, q yg salah kacih remarks untuk "j". "Dim j as String" en "Dim j as Range" duanyanya gag jalan. maklum masih belon ngerti fungsi/tujuannya, jadi q tebak2 az xi...xi...xi...

Re: [belajar-excel] Placed Result

2010-02-21 Terurut Topik Khozhot
)>semoga bermanfaatFrom: Khozhot To: belajar-excel@yahoogroups.comSent: Mon, February 22, 2010 8:48:15 AMSubject: Re: [belajar-excel] Placed Result Kalo yang ini q test koq gag bisa jalan yach.-- Wassalamzhot theaUsing Opera's revolutionary e-mail client: http://www.opera.com/mail/On Sun

Re: [belajar-excel] Placed Result

2010-02-21 Terurut Topik Khozhot
End Sub selamat belajar. >semoga bermanfaat From: Khozhot To: belajar-excel@yahoogroups.comSent: Sat, February 20, 2010 3:38:51 PMSubject: Re: [belajar-excel] Placed Result Alhamdulillah,..Siii...p dach. Ini yang kumaThanks yach.q pelajari lagi ach..-- Wassalamzhot

Re: [belajar-excel] Placed Result

2010-02-20 Terurut Topik anton suryadi
j = 0 End If Next n End If Next i End Sub selamat belajar. >semoga bermanfaat From: Khozhot To: belajar-excel@yahoogroups.com Sent: Sat, February 20, 2010 3:38:51 PM Subject: Re: [belajar-excel] Placed Result Alhamd

Re: [belajar-excel] Placed Result

2010-02-20 Terurut Topik Khozhot
tidak jadi memberi saran) karena ternyata tombol-tombol itu untuk menjalankan contoh² makro dari berbagai member.. sorrriii       - Original Message - From: siti Vi To: belajar-excel@yahoogroups.com Sent: Saturday, February 20, 2010 10:30 AM Subject: Re: [belajar-ex

Re: [belajar-excel] Placed Result

2010-02-19 Terurut Topik Khozhot
ion.CutCopyMode = FalseEnd Sub lihat lampiran     - Original Message - From: Khozhot To: belajar-excel@yahoogroups.com Sent: Saturday, February 20, 2010 8:36 AM Subject: Re: [belajar-excel] Placed Result Dear Suhus, Lampiran saya coba edit dikit dengan nambahin baris SUM,

Re: [belajar-excel] Placed Result

2010-02-19 Terurut Topik anton suryadi
From: anton suryadi To: belajar-excel@yahoogroups.com Sent: Fri, February 19, 2010 4:43:37 PM Subject: Re: [belajar-excel] Placed Result pak Kozhot, kalo gini gimana, Sub Updating_Click( ) LR = Cells(Rows.Count, 1).End(xlUp) .Row LC = Cells(4, Columns.Count) .End(xlToLeft) .Colu

Re: [belajar-excel] Placed Result

2010-02-19 Terurut Topik anton suryadi
Cells(4 + n, i) = "=VLOOKUP(A" & (4 + n) & ",Source!$A$2:$B$9,2,0)" Next n End If Next i End Sub >semoga bermanfaat From: Khozhot To: belajar-excel@yahoogroups.com Sent: Fri, February 19, 2010 4:10:25 PM Sub

Re: [belajar-excel] Placed Result

2010-02-19 Terurut Topik anton suryadi
t;End Sub > > >>semoga bermanfaat > > > > > > > > ________________ From: hery wahyudi >To: belajar-excel@yahoogroups.com >Sent: Fri, February 19, 2010 2:43:09 PM >Subject: Re: [belajar-excel] Placed Result > > > > > >>

Re: [belajar-excel] Placed Result

2010-02-19 Terurut Topik Khozhot
(4, i) = Range("B2") Then    For n = 1 To LR - 4    Cells(4 + n, i) = "=VLOOKUP(A" & (4 + n) & ",Source!$A$2:$B$9,2,0)"    Next n    End IfNext iEnd Sub>semoga bermanfaatFrom: hery wahyudi To: belajar-excel@yahoogroups.comSent: Fri, February

Re: [belajar-excel] Placed Result

2010-02-19 Terurut Topik Khozhot
Title: Template Dear Pak Hery,Bener banged yang kayak geneech yang q mauk, meskipun belon ngerti cara membaca codingannya.hatur nuhun.-- Wassalamzhot theaUsing Opera's revolutionary e-mail client: http://www.opera.com/mail/On Fri, 19 Feb 2010 14:43:09 +0700, hery wahyudi wrote:  

Re: [belajar-excel] Placed Result

2010-02-19 Terurut Topik anton suryadi
$B$9,2,0)" Next n End If Next i End Sub >semoga bermanfaat From: hery wahyudi To: belajar-excel@yahoogroups.com Sent: Fri, February 19, 2010 2:43:09 PM Subject: Re: [belajar-excel] Placed Result mungkin seperti data terlampir

[belajar-excel] Placed Result

2010-02-18 Terurut Topik Khozhot
Dear Suhu,Ada lagee yg mo ditanyain nech.Kucoba coba merangkai kodeKode kurangkai... error ku dapatKucoba-coba menganti kode.Kode ku tetap error ku dapatxi...xi...xi...Bukan syair lagu tapi mirip.nyanyiin az heu...heuheu...Intinya masih terus pengen belajar dengan kinds of ca