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
, 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
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
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
, 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...
)>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
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
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
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
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,
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
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
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
>
> >
>
>
>>
(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
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:
$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
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
17 matches
Mail list logo