Private Sub Worksheet_Change(ByVal Target As Range)If Target.Address = "$A$12"
ThenActiveSheet.Range("$B$12:$C$20").AutoFilter Field:=1, Criteria1:="<>" &
"#NUM!"ElseEnd IfEnd Sub
yang terblok kuning cell rujukan yang akan di filter, dan yang berwarna biru
itu range data yang akan di filter.pastikan bahwa cekrip di atas di taruh di
worksheet yang bersangkutan, JANGAN di SHEET LAIN...!!! br,
odong nando
Dari: "azafaza [email protected] [belajar-excel]"
<[email protected]>
Kepada: "[email protected]" <[email protected]>
Dikirim: Selasa, 4 Oktober 2016 9:03
Judul: Re: Bls: [belajar-excel] Help : Apakah tinggi Row bisa diatur pakai
formula
Maaf...mohon diberikan step2nya kalo mau dicopy ke file lain...soalnya saya
coba masih belum bisa..trima kasih
#yiv0405669741 #yiv0405669741 -- #yiv0405669741ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0405669741
#yiv0405669741ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0405669741
#yiv0405669741ygrp-mkp #yiv0405669741hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0405669741 #yiv0405669741ygrp-mkp #yiv0405669741ads
{margin-bottom:10px;}#yiv0405669741 #yiv0405669741ygrp-mkp .yiv0405669741ad
{padding:0 0;}#yiv0405669741 #yiv0405669741ygrp-mkp .yiv0405669741ad p
{margin:0;}#yiv0405669741 #yiv0405669741ygrp-mkp .yiv0405669741ad a
{color:#0000ff;text-decoration:none;}#yiv0405669741 #yiv0405669741ygrp-sponsor
#yiv0405669741ygrp-lc {font-family:Arial;}#yiv0405669741
#yiv0405669741ygrp-sponsor #yiv0405669741ygrp-lc #yiv0405669741hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0405669741
#yiv0405669741ygrp-sponsor #yiv0405669741ygrp-lc .yiv0405669741ad
{margin-bottom:10px;padding:0 0;}#yiv0405669741 #yiv0405669741actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0405669741
#yiv0405669741activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0405669741
#yiv0405669741activity span {font-weight:700;}#yiv0405669741
#yiv0405669741activity span:first-child
{text-transform:uppercase;}#yiv0405669741 #yiv0405669741activity span a
{color:#5085b6;text-decoration:none;}#yiv0405669741 #yiv0405669741activity span
span {color:#ff7900;}#yiv0405669741 #yiv0405669741activity span
.yiv0405669741underline {text-decoration:underline;}#yiv0405669741
.yiv0405669741attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0405669741 .yiv0405669741attach div a
{text-decoration:none;}#yiv0405669741 .yiv0405669741attach img
{border:none;padding-right:5px;}#yiv0405669741 .yiv0405669741attach label
{display:block;margin-bottom:5px;}#yiv0405669741 .yiv0405669741attach label a
{text-decoration:none;}#yiv0405669741 blockquote {margin:0 0 0
4px;}#yiv0405669741 .yiv0405669741bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0405669741
.yiv0405669741bold a {text-decoration:none;}#yiv0405669741 dd.yiv0405669741last
p a {font-family:Verdana;font-weight:700;}#yiv0405669741 dd.yiv0405669741last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0405669741
dd.yiv0405669741last p span.yiv0405669741yshortcuts
{margin-right:0;}#yiv0405669741 div.yiv0405669741attach-table div div a
{text-decoration:none;}#yiv0405669741 div.yiv0405669741attach-table
{width:400px;}#yiv0405669741 div.yiv0405669741file-title a, #yiv0405669741
div.yiv0405669741file-title a:active, #yiv0405669741
div.yiv0405669741file-title a:hover, #yiv0405669741 div.yiv0405669741file-title
a:visited {text-decoration:none;}#yiv0405669741 div.yiv0405669741photo-title a,
#yiv0405669741 div.yiv0405669741photo-title a:active, #yiv0405669741
div.yiv0405669741photo-title a:hover, #yiv0405669741
div.yiv0405669741photo-title a:visited {text-decoration:none;}#yiv0405669741
div#yiv0405669741ygrp-mlmsg #yiv0405669741ygrp-msg p a
span.yiv0405669741yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0405669741
.yiv0405669741green {color:#628c2a;}#yiv0405669741 .yiv0405669741MsoNormal
{margin:0 0 0 0;}#yiv0405669741 o {font-size:0;}#yiv0405669741
#yiv0405669741photos div {float:left;width:72px;}#yiv0405669741
#yiv0405669741photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0405669741
#yiv0405669741photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0405669741
#yiv0405669741reco-category {font-size:77%;}#yiv0405669741
#yiv0405669741reco-desc {font-size:77%;}#yiv0405669741 .yiv0405669741replbq
{margin:4px;}#yiv0405669741 #yiv0405669741ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0405669741 #yiv0405669741ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0405669741
#yiv0405669741ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0405669741
#yiv0405669741ygrp-mlmsg select, #yiv0405669741 input, #yiv0405669741 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0405669741
#yiv0405669741ygrp-mlmsg pre, #yiv0405669741 code {font:115%
monospace;}#yiv0405669741 #yiv0405669741ygrp-mlmsg *
{line-height:1.22em;}#yiv0405669741 #yiv0405669741ygrp-mlmsg #yiv0405669741logo
{padding-bottom:10px;}#yiv0405669741 #yiv0405669741ygrp-msg p a
{font-family:Verdana;}#yiv0405669741 #yiv0405669741ygrp-msg
p#yiv0405669741attach-count span {color:#1E66AE;font-weight:700;}#yiv0405669741
#yiv0405669741ygrp-reco #yiv0405669741reco-head
{color:#ff7900;font-weight:700;}#yiv0405669741 #yiv0405669741ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0405669741 #yiv0405669741ygrp-sponsor
#yiv0405669741ov li a {font-size:130%;text-decoration:none;}#yiv0405669741
#yiv0405669741ygrp-sponsor #yiv0405669741ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0405669741
#yiv0405669741ygrp-sponsor #yiv0405669741ov ul {margin:0;padding:0 0 0
8px;}#yiv0405669741 #yiv0405669741ygrp-text
{font-family:Georgia;}#yiv0405669741 #yiv0405669741ygrp-text p {margin:0 0 1em
0;}#yiv0405669741 #yiv0405669741ygrp-text tt {font-size:120%;}#yiv0405669741
#yiv0405669741ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0405669741
