Coba cek kembali formulanya.Perintah untuk mencetak....ActiveSheet.PrintOut
(asumsi sdh diset area cetaknya).
Salam,HK
From: "Armia Abbas [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 23 December 2015, 8:28
Subject: [belajar-excel] menampilkan hasil filter ke sheet lain dan
mencetaknya [1 Attachment]
Dear BeExceller,
Kasus ini adalah menyaring data berdasarkan suatu kriteria tertentu ke sheet
lain. Kriteria filter diubah dengan sebuah spin button. Hasil filter kemudian
dicetak.
Pada file terlampir, formula untuk mengambil data terfilter sesuai kriteria
masih menghasilkan error value.
Proses mencetaknya juga belum dibuat.
Mohon bantuan rekan BeExceller tentang langkah perbaikannya.
Terimakasih atas bantuannya.
Atas nama penanya,
Tim Moderator Belajar-Excel
--- Mods ---
Dimohon, untuk memberi subject email dengan kalimat singkat yang mewakili kasus
yang diutarakan.
Dimohon juga, untuk menuliskan beberapa kalimat penjelasan singkat tentang
kasus yang diutarakan di dalam body email, sebagai bagian dari kewajaran dan
kesantunan dalam surat menyurat.
---------------
#yiv9512440673 #yiv9512440673 -- #yiv9512440673ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9512440673
#yiv9512440673ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9512440673
#yiv9512440673ygrp-mkp #yiv9512440673hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9512440673 #yiv9512440673ygrp-mkp #yiv9512440673ads
{margin-bottom:10px;}#yiv9512440673 #yiv9512440673ygrp-mkp .yiv9512440673ad
{padding:0 0;}#yiv9512440673 #yiv9512440673ygrp-mkp .yiv9512440673ad p
{margin:0;}#yiv9512440673 #yiv9512440673ygrp-mkp .yiv9512440673ad a
{color:#0000ff;text-decoration:none;}#yiv9512440673 #yiv9512440673ygrp-sponsor
#yiv9512440673ygrp-lc {font-family:Arial;}#yiv9512440673
#yiv9512440673ygrp-sponsor #yiv9512440673ygrp-lc #yiv9512440673hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9512440673
#yiv9512440673ygrp-sponsor #yiv9512440673ygrp-lc .yiv9512440673ad
{margin-bottom:10px;padding:0 0;}#yiv9512440673 #yiv9512440673actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9512440673
#yiv9512440673activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9512440673
#yiv9512440673activity span {font-weight:700;}#yiv9512440673
#yiv9512440673activity span:first-child
{text-transform:uppercase;}#yiv9512440673 #yiv9512440673activity span a
{color:#5085b6;text-decoration:none;}#yiv9512440673 #yiv9512440673activity span
span {color:#ff7900;}#yiv9512440673 #yiv9512440673activity span
.yiv9512440673underline {text-decoration:underline;}#yiv9512440673
.yiv9512440673attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9512440673 .yiv9512440673attach div a
{text-decoration:none;}#yiv9512440673 .yiv9512440673attach img
{border:none;padding-right:5px;}#yiv9512440673 .yiv9512440673attach label
{display:block;margin-bottom:5px;}#yiv9512440673 .yiv9512440673attach label a
{text-decoration:none;}#yiv9512440673 blockquote {margin:0 0 0
4px;}#yiv9512440673 .yiv9512440673bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9512440673
.yiv9512440673bold a {text-decoration:none;}#yiv9512440673 dd.yiv9512440673last
p a {font-family:Verdana;font-weight:700;}#yiv9512440673 dd.yiv9512440673last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9512440673
dd.yiv9512440673last p span.yiv9512440673yshortcuts
{margin-right:0;}#yiv9512440673 div.yiv9512440673attach-table div div a
{text-decoration:none;}#yiv9512440673 div.yiv9512440673attach-table
{width:400px;}#yiv9512440673 div.yiv9512440673file-title a, #yiv9512440673
div.yiv9512440673file-title a:active, #yiv9512440673
div.yiv9512440673file-title a:hover, #yiv9512440673 div.yiv9512440673file-title
a:visited {text-decoration:none;}#yiv9512440673 div.yiv9512440673photo-title a,
#yiv9512440673 div.yiv9512440673photo-title a:active, #yiv9512440673
div.yiv9512440673photo-title a:hover, #yiv9512440673
div.yiv9512440673photo-title a:visited {text-decoration:none;}#yiv9512440673
div#yiv9512440673ygrp-mlmsg #yiv9512440673ygrp-msg p a
span.yiv9512440673yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9512440673
.yiv9512440673green {color:#628c2a;}#yiv9512440673 .yiv9512440673MsoNormal
{margin:0 0 0 0;}#yiv9512440673 o {font-size:0;}#yiv9512440673
#yiv9512440673photos div {float:left;width:72px;}#yiv9512440673
#yiv9512440673photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9512440673
#yiv9512440673photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9512440673
#yiv9512440673reco-category {font-size:77%;}#yiv9512440673
#yiv9512440673reco-desc {font-size:77%;}#yiv9512440673 .yiv9512440673replbq
{margin:4px;}#yiv9512440673 #yiv9512440673ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9512440673 #yiv9512440673ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9512440673
#yiv9512440673ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9512440673
#yiv9512440673ygrp-mlmsg select, #yiv9512440673 input, #yiv9512440673 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9512440673
#yiv9512440673ygrp-mlmsg pre, #yiv9512440673 code {font:115%
monospace;}#yiv9512440673 #yiv9512440673ygrp-mlmsg *
{line-height:1.22em;}#yiv9512440673 #yiv9512440673ygrp-mlmsg #yiv9512440673logo
{padding-bottom:10px;}#yiv9512440673 #yiv9512440673ygrp-msg p a
{font-family:Verdana;}#yiv9512440673 #yiv9512440673ygrp-msg
p#yiv9512440673attach-count span {color:#1E66AE;font-weight:700;}#yiv9512440673
#yiv9512440673ygrp-reco #yiv9512440673reco-head
{color:#ff7900;font-weight:700;}#yiv9512440673 #yiv9512440673ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9512440673 #yiv9512440673ygrp-sponsor
#yiv9512440673ov li a {font-size:130%;text-decoration:none;}#yiv9512440673
#yiv9512440673ygrp-sponsor #yiv9512440673ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9512440673
#yiv9512440673ygrp-sponsor #yiv9512440673ov ul {margin:0;padding:0 0 0
8px;}#yiv9512440673 #yiv9512440673ygrp-text
{font-family:Georgia;}#yiv9512440673 #yiv9512440673ygrp-text p {margin:0 0 1em
0;}#yiv9512440673 #yiv9512440673ygrp-text tt {font-size:120%;}#yiv9512440673
#yiv9512440673ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9512440673
