Hai Seismica,Disitu kan ada dari... sampai...Tinggal PrintPreviewnya diganti
dengan PrintOut.
Salam,HK
From: "Zerlinda Seismica [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 22 July 2015, 16:03
Subject: Bls: Fw: [belajar-excel] Mencetak dengan macro
Lanjut tanya mas HK...alhamdulilah macronya berjalan tapi apakah memang
jalannya harus tetep satu-satu printnya?maksudnya misalkan mau print dari 1-10
maka printer otomatis akan print 10 kali dengan data yang ada sambil kita
tinggal minum coklat...
SalamSeismica
Pada Kamis, 28 Mei 2015 13:50, "Hendrik Karnadi [email protected]
[belajar-excel]" <[email protected]> menulis:
Sama2.Memang macronya tidak harus persis sama...yang penting bisa memenuhi
kebutuhan.
Salam,HK
Sent from Samsung Mobile
-------- Original message --------From: "heru mulyono [email protected]
[belajar-excel]" Date:28/05/2015 12:54 PM (GMT+07:00) To:
[email protected] Subject: Re: Fw: [belajar-excel] Mencetak dengan
macro
YthMas Nang Agus dan HKMaaf Mas nang Agus saya lupa (maklum masih
belajar)...baru mau saya kirimkan, ternyata sdh ada mas HK, dgn rumus makro
yang hampir sama
untuk mas HK, terimakasih atas solusinyadengan sedikit modifikasi, rumus bisa
berjalan dengan baikterimakasih semuanya
2015-05-28 12:31 GMT+07:00 hendrik karnadi [email protected]
[belajar-excel] <[email protected]>:
Yang dicopy haya yang berwarna biru, yang hitam otomatis dicreate oleh
computer.
Salam,HK
----- Forwarded Message -----
From: hendrik karnadi <[email protected]>
To: "[email protected]" <[email protected]>
Sent: Thursday, 28 May 2015, 12:28
Subject: Re: [belajar-excel] Mencetak dengan macro [1 Attachment]
Arahkan sel ponter ke "Design Mode" (sub Menu "Developer")Klik kiri MouseKlik
kanan Mouse pada tombol "Cetak" lalu klik "View Code"Copas Macro ini:Private
Sub CommandButton2_Click() Dim i As Integer For i = Range("AM18") To
Range("AO18").Value SpinButton1.Value = i
ActiveSheet.PrintPreview Next iEnd Sub
Jangan lupa simpan sebagai Macro FileVersi 2003 (.xls)Versus 2007 ke atas
(.xlsm, .xlsb)dan aktifkan macronya sebelum dijalankan.
Semoga membantu.
Salam
From: "heru mulyono [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Thursday, 28 May 2015, 10:15
Subject: [belajar-excel] Mencetak dengan macro [1 Attachment]
Yth Be-ExcellerMohon bantuan atas permasalahan saya.file
terlampirterimakasih
#yiv8951594575 #yiv8951594575 -- #yiv8951594575ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8951594575
#yiv8951594575ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8951594575
#yiv8951594575ygrp-mkp #yiv8951594575hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8951594575 #yiv8951594575ygrp-mkp #yiv8951594575ads
{margin-bottom:10px;}#yiv8951594575 #yiv8951594575ygrp-mkp .yiv8951594575ad
{padding:0 0;}#yiv8951594575 #yiv8951594575ygrp-mkp .yiv8951594575ad p
{margin:0;}#yiv8951594575 #yiv8951594575ygrp-mkp .yiv8951594575ad a
{color:#0000ff;text-decoration:none;}#yiv8951594575 #yiv8951594575ygrp-sponsor
#yiv8951594575ygrp-lc {font-family:Arial;}#yiv8951594575
#yiv8951594575ygrp-sponsor #yiv8951594575ygrp-lc #yiv8951594575hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8951594575
#yiv8951594575ygrp-sponsor #yiv8951594575ygrp-lc .yiv8951594575ad
{margin-bottom:10px;padding:0 0;}#yiv8951594575 #yiv8951594575actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8951594575
#yiv8951594575activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8951594575
#yiv8951594575activity span {font-weight:700;}#yiv8951594575
#yiv8951594575activity span:first-child
{text-transform:uppercase;}#yiv8951594575 #yiv8951594575activity span a
{color:#5085b6;text-decoration:none;}#yiv8951594575 #yiv8951594575activity span
span {color:#ff7900;}#yiv8951594575 #yiv8951594575activity span
.yiv8951594575underline {text-decoration:underline;}#yiv8951594575
.yiv8951594575attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8951594575 .yiv8951594575attach div a
{text-decoration:none;}#yiv8951594575 .yiv8951594575attach img
{border:none;padding-right:5px;}#yiv8951594575 .yiv8951594575attach label
{display:block;margin-bottom:5px;}#yiv8951594575 .yiv8951594575attach label a
{text-decoration:none;}#yiv8951594575 blockquote {margin:0 0 0
4px;}#yiv8951594575 .yiv8951594575bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8951594575
.yiv8951594575bold a {text-decoration:none;}#yiv8951594575 dd.yiv8951594575last
p a {font-family:Verdana;font-weight:700;}#yiv8951594575 dd.yiv8951594575last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8951594575
dd.yiv8951594575last p span.yiv8951594575yshortcuts
{margin-right:0;}#yiv8951594575 div.yiv8951594575attach-table div div a
{text-decoration:none;}#yiv8951594575 div.yiv8951594575attach-table
{width:400px;}#yiv8951594575 div.yiv8951594575file-title a, #yiv8951594575
div.yiv8951594575file-title a:active, #yiv8951594575
div.yiv8951594575file-title a:hover, #yiv8951594575 div.yiv8951594575file-title
a:visited {text-decoration:none;}#yiv8951594575 div.yiv8951594575photo-title a,
#yiv8951594575 div.yiv8951594575photo-title a:active, #yiv8951594575
div.yiv8951594575photo-title a:hover, #yiv8951594575
div.yiv8951594575photo-title a:visited {text-decoration:none;}#yiv8951594575
div#yiv8951594575ygrp-mlmsg #yiv8951594575ygrp-msg p a
span.yiv8951594575yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8951594575
.yiv8951594575green {color:#628c2a;}#yiv8951594575 .yiv8951594575MsoNormal
{margin:0 0 0 0;}#yiv8951594575 o {font-size:0;}#yiv8951594575
#yiv8951594575photos div {float:left;width:72px;}#yiv8951594575
#yiv8951594575photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8951594575
#yiv8951594575photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8951594575
#yiv8951594575reco-category {font-size:77%;}#yiv8951594575
#yiv8951594575reco-desc {font-size:77%;}#yiv8951594575 .yiv8951594575replbq
{margin:4px;}#yiv8951594575 #yiv8951594575ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8951594575 #yiv8951594575ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8951594575
#yiv8951594575ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8951594575
#yiv8951594575ygrp-mlmsg select, #yiv8951594575 input, #yiv8951594575 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8951594575
#yiv8951594575ygrp-mlmsg pre, #yiv8951594575 code {font:115%
monospace;}#yiv8951594575 #yiv8951594575ygrp-mlmsg *
{line-height:1.22em;}#yiv8951594575 #yiv8951594575ygrp-mlmsg #yiv8951594575logo
{padding-bottom:10px;}#yiv8951594575 #yiv8951594575ygrp-msg p a
{font-family:Verdana;}#yiv8951594575 #yiv8951594575ygrp-msg
p#yiv8951594575attach-count span {color:#1E66AE;font-weight:700;}#yiv8951594575
#yiv8951594575ygrp-reco #yiv8951594575reco-head
{color:#ff7900;font-weight:700;}#yiv8951594575 #yiv8951594575ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8951594575 #yiv8951594575ygrp-sponsor
#yiv8951594575ov li a {font-size:130%;text-decoration:none;}#yiv8951594575
#yiv8951594575ygrp-sponsor #yiv8951594575ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8951594575
#yiv8951594575ygrp-sponsor #yiv8951594575ov ul {margin:0;padding:0 0 0
8px;}#yiv8951594575 #yiv8951594575ygrp-text
{font-family:Georgia;}#yiv8951594575 #yiv8951594575ygrp-text p {margin:0 0 1em
0;}#yiv8951594575 #yiv8951594575ygrp-text tt {font-size:120%;}#yiv8951594575
#yiv8951594575ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8951594575
