Selamat Pagi Be exceller,
Mr. Kid,
Terima kasih bantuannya,
Kita coba :)
Salam,
Kelik
-----Original Message-----
From: [email protected] [mailto:[email protected]]
On Behalf Of Mr. Kid
Sent: 01 Maret 2013 19:39
To: [email protected]
Subject: Re: [belajar-excel] Rekap ke samping
Pada prosedur yang dipanggil oleh tombol rekap isi dengan :
sheets("CDI").range("g1:g103").copy
sheets("Rekap").range("a1").offset(0,
sheets("rekap").range("a1").currentregion.columns.count ).pastespecial
xlpastevaluesandnumberformats
Wassalam,
Kid.
2013/3/1 Kelik Pitoyo <[email protected]>
Selamat Sore be Exceller,
Sebelumnya terima kasih bantuan sebelumnya dari Mr. Kid.
Sekarang minta tolong lagi kepada semua master :)
Masalahnya:
Ingin merekap, hasil di sheet "CDI" dikopi paste ke Sheet "Rekap"
tapi hasil copy berikutnya ke samping. Mohon bantuannya, supaya hasilnya
tidak menumpuk dng, data lama.
Terima kasih,
Salam,
Kelik
------------------------------------
---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
[email protected]
posting ke milis, kirimkan ke:
[email protected]
berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran
http://www.mail-archive.com/[email protected]/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: [email protected]
keluar dari membership milis (UnSubscribe):
kirim mail kosong ke [email protected]
---------------------------------------------------------------------Yahoo!
Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-excel/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-excel/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
