Sambil menunggu kiriman ulang file lampirannya, barangkali file terlampir bisa
menjadi rujukan.
Salam,HK
From: "Irham M [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Monday, 4 May 2015, 8:44
Subject: [belajar-excel] Print Vlookup Seperti Mailmerge
Selamat PagiSaya mohon bantuan bagaimana assign macro untuk membuat tombol
perintah print, yang bisa mencetak seluruh data sepert pada perintah print all
di Mailmerge Ms. WordBerikut saya lampirkan filenya.Bagaimana cara mencetak
"Format Rapot" tanpa harus mengganti nomor urut secara manualTerima kasih
--- Mods ---
File lampiran yang lebih dari 250KB dilepas dari email. Silakan penanya
mengirim ulang file lampiran yang diusahakan maksimal 250KB dengan cara
me-reply email ini.
---------------
#yiv8480527569 #yiv8480527569 -- #yiv8480527569ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8480527569
#yiv8480527569ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8480527569
#yiv8480527569ygrp-mkp #yiv8480527569hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8480527569 #yiv8480527569ygrp-mkp #yiv8480527569ads
{margin-bottom:10px;}#yiv8480527569 #yiv8480527569ygrp-mkp .yiv8480527569ad
{padding:0 0;}#yiv8480527569 #yiv8480527569ygrp-mkp .yiv8480527569ad p
{margin:0;}#yiv8480527569 #yiv8480527569ygrp-mkp .yiv8480527569ad a
{color:#0000ff;text-decoration:none;}#yiv8480527569 #yiv8480527569ygrp-sponsor
#yiv8480527569ygrp-lc {font-family:Arial;}#yiv8480527569
#yiv8480527569ygrp-sponsor #yiv8480527569ygrp-lc #yiv8480527569hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8480527569
#yiv8480527569ygrp-sponsor #yiv8480527569ygrp-lc .yiv8480527569ad
{margin-bottom:10px;padding:0 0;}#yiv8480527569 #yiv8480527569actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8480527569
#yiv8480527569activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8480527569
#yiv8480527569activity span {font-weight:700;}#yiv8480527569
#yiv8480527569activity span:first-child
{text-transform:uppercase;}#yiv8480527569 #yiv8480527569activity span a
{color:#5085b6;text-decoration:none;}#yiv8480527569 #yiv8480527569activity span
span {color:#ff7900;}#yiv8480527569 #yiv8480527569activity span
.yiv8480527569underline {text-decoration:underline;}#yiv8480527569
.yiv8480527569attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8480527569 .yiv8480527569attach div a
{text-decoration:none;}#yiv8480527569 .yiv8480527569attach img
{border:none;padding-right:5px;}#yiv8480527569 .yiv8480527569attach label
{display:block;margin-bottom:5px;}#yiv8480527569 .yiv8480527569attach label a
{text-decoration:none;}#yiv8480527569 blockquote {margin:0 0 0
4px;}#yiv8480527569 .yiv8480527569bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8480527569
.yiv8480527569bold a {text-decoration:none;}#yiv8480527569 dd.yiv8480527569last
p a {font-family:Verdana;font-weight:700;}#yiv8480527569 dd.yiv8480527569last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8480527569
dd.yiv8480527569last p span.yiv8480527569yshortcuts
{margin-right:0;}#yiv8480527569 div.yiv8480527569attach-table div div a
{text-decoration:none;}#yiv8480527569 div.yiv8480527569attach-table
{width:400px;}#yiv8480527569 div.yiv8480527569file-title a, #yiv8480527569
div.yiv8480527569file-title a:active, #yiv8480527569
div.yiv8480527569file-title a:hover, #yiv8480527569 div.yiv8480527569file-title
a:visited {text-decoration:none;}#yiv8480527569 div.yiv8480527569photo-title a,
#yiv8480527569 div.yiv8480527569photo-title a:active, #yiv8480527569
div.yiv8480527569photo-title a:hover, #yiv8480527569
div.yiv8480527569photo-title a:visited {text-decoration:none;}#yiv8480527569
div#yiv8480527569ygrp-mlmsg #yiv8480527569ygrp-msg p a
span.yiv8480527569yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8480527569
.yiv8480527569green {color:#628c2a;}#yiv8480527569 .yiv8480527569MsoNormal
{margin:0 0 0 0;}#yiv8480527569 o {font-size:0;}#yiv8480527569
#yiv8480527569photos div {float:left;width:72px;}#yiv8480527569
#yiv8480527569photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8480527569
#yiv8480527569photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8480527569
#yiv8480527569reco-category {font-size:77%;}#yiv8480527569
#yiv8480527569reco-desc {font-size:77%;}#yiv8480527569 .yiv8480527569replbq
{margin:4px;}#yiv8480527569 #yiv8480527569ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8480527569 #yiv8480527569ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8480527569
#yiv8480527569ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8480527569
#yiv8480527569ygrp-mlmsg select, #yiv8480527569 input, #yiv8480527569 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8480527569
#yiv8480527569ygrp-mlmsg pre, #yiv8480527569 code {font:115%
monospace;}#yiv8480527569 #yiv8480527569ygrp-mlmsg *
{line-height:1.22em;}#yiv8480527569 #yiv8480527569ygrp-mlmsg #yiv8480527569logo
{padding-bottom:10px;}#yiv8480527569 #yiv8480527569ygrp-msg p a
{font-family:Verdana;}#yiv8480527569 #yiv8480527569ygrp-msg
p#yiv8480527569attach-count span {color:#1E66AE;font-weight:700;}#yiv8480527569
#yiv8480527569ygrp-reco #yiv8480527569reco-head
{color:#ff7900;font-weight:700;}#yiv8480527569 #yiv8480527569ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8480527569 #yiv8480527569ygrp-sponsor
#yiv8480527569ov li a {font-size:130%;text-decoration:none;}#yiv8480527569
#yiv8480527569ygrp-sponsor #yiv8480527569ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8480527569
#yiv8480527569ygrp-sponsor #yiv8480527569ov ul {margin:0;padding:0 0 0
8px;}#yiv8480527569 #yiv8480527569ygrp-text
{font-family:Georgia;}#yiv8480527569 #yiv8480527569ygrp-text p {margin:0 0 1em
0;}#yiv8480527569 #yiv8480527569ygrp-text tt {font-size:120%;}#yiv8480527569
#yiv8480527569ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8480527569
Cetak Otomatis(2.2.13).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
