Dear DD, Kalo di lihat permasalahan adalah pada
Sheet12.Range("X70").Value,Sheet12.Range("AK70").Value,Sheet12.Range("AX70").Value
merupakan nilai,jika terdapat error value maka fungsi IF nya tidak bekeja
dengan baik, untuk mngatasinya kamu harus tambahkan formula IFERROR pada nilai
SUM di Range2 tersebut sehingga fungsi IF bisa bekeja sesuai dengan keadaan,
jika kondisi ERROR VALUE, si fungsi IF bingung untuk mengkodisikan apa yang
sebenarnya,Begitu pula untuk Sheet13. Selamat mencoba. TerimaKasih.
Pada Kamis, 30 April 2015 12:16, "Dede [email protected]
[belajar-excel]" <[email protected]> menulis:
DearMr Kid and Mr Toby, Berhubungada dua versi jadi saya pake keduanya
deh, Sayaada sedikit lagi masalah dengan file terlampir di sheet yang saya beri
warnamerah. Hidebaris sudah ok, hanya saya baru sesuai harapan kalau saya
berpindah dulu kesheet lain baru saya tengok kembali sheet semula. Yangkurang
tepat apa yah Mr...? Salam, DD From: Toby [email protected]
[belajar-excel] [mailto:[email protected]]
Sent: 30 April 2015 08:24
To: [email protected]
Subject: Bls: [belajar-excel] Hiden Otomatis [1 Attachment] Dear DD,
Sorry agak telat, mungkin file ini jugabisa membantu.. TerimaKasih.
Pada Kamis, 30 April 2015 8:18,"Dede [email protected]
[belajar-excel]"<[email protected]> menulis: Dear Mr Kid,
Sukses sekali, terimakasih atas bantuannya. Semoga Anda selalu diberi kesehatan
dan keberkahansehingga tidak bosan-bosan untuk selalu memberi penerangan dalam
kegelapan. Dan Mr Toby terimakasih atas bantuannya pula, maaf sudah rewel dan
merepotkan. Sukses selaluuntuk Anda semua yang ada di komunitas BeExceller ini.
Salam, DD From: 'Mr.Kid' [email protected] [belajar-excel]
[mailto:[email protected]]
Sent: 29 April 2015 19:45
To: BeExcel
Subject: Re: [belajar-excel] Hiden Otomatis [1 Attachment] Hai DD, File
terlampir. Wassalam, Kid On Tue, Apr 28, 2015 at 6:49 PM, Dede
[email protected][belajar-excel] <[email protected]>
wrote: Dear BeExceller, Bisakan sebuah ROW danCOLUMN ter”Hide” otomatis ?
Ini pengembangan kasushyperlink tadi, semoga teman-teman tidak bosan yah...
Tinggal satu langkahlagi untuk menyempurnakan report terlampir, yaitu dengan
meng”Hide” otomatisbaris kosong di sheet “View” dan kolom yang tidak ada
datanya pada saat sayaklik kode subdist di sheet “List Kirim GT” apakah hal itu
memungkinkan ? Mohon pencerahannyadari para master sekalian. Salam, DD This
e-mail and any filestransmitted with it are confidential and intended solely
for the use of theindividual to whom it is addressed. If you have received this
email in errorplease send it back to the person that sent it to you. Any views
or opinionspresented are solely those of its author and do not necessarily
represent thoseof NABATI or any of its subsidiary companies. Unauthorized
publication, use,dissemination, forwarding, printing or copying of this email
and its associatedattachments is strictly prohibited. #yiv9287773430
#yiv9287773430 -- #yiv9287773430ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9287773430
#yiv9287773430ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9287773430
#yiv9287773430ygrp-mkp #yiv9287773430hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9287773430 #yiv9287773430ygrp-mkp #yiv9287773430ads
{margin-bottom:10px;}#yiv9287773430 #yiv9287773430ygrp-mkp .yiv9287773430ad
{padding:0 0;}#yiv9287773430 #yiv9287773430ygrp-mkp .yiv9287773430ad p
{margin:0;}#yiv9287773430 #yiv9287773430ygrp-mkp .yiv9287773430ad a
{color:#0000ff;text-decoration:none;}#yiv9287773430 #yiv9287773430ygrp-sponsor
#yiv9287773430ygrp-lc {font-family:Arial;}#yiv9287773430
#yiv9287773430ygrp-sponsor #yiv9287773430ygrp-lc #yiv9287773430hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9287773430
#yiv9287773430ygrp-sponsor #yiv9287773430ygrp-lc .yiv9287773430ad
{margin-bottom:10px;padding:0 0;}#yiv9287773430 #yiv9287773430actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9287773430
#yiv9287773430activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9287773430
#yiv9287773430activity span {font-weight:700;}#yiv9287773430
#yiv9287773430activity span:first-child
{text-transform:uppercase;}#yiv9287773430 #yiv9287773430activity span a
{color:#5085b6;text-decoration:none;}#yiv9287773430 #yiv9287773430activity span
span {color:#ff7900;}#yiv9287773430 #yiv9287773430activity span
.yiv9287773430underline {text-decoration:underline;}#yiv9287773430
.yiv9287773430attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9287773430 .yiv9287773430attach div a
{text-decoration:none;}#yiv9287773430 .yiv9287773430attach img
{border:none;padding-right:5px;}#yiv9287773430 .yiv9287773430attach label
{display:block;margin-bottom:5px;}#yiv9287773430 .yiv9287773430attach label a
{text-decoration:none;}#yiv9287773430 blockquote {margin:0 0 0
4px;}#yiv9287773430 .yiv9287773430bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9287773430
.yiv9287773430bold a {text-decoration:none;}#yiv9287773430 dd.yiv9287773430last
p a {font-family:Verdana;font-weight:700;}#yiv9287773430 dd.yiv9287773430last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9287773430
dd.yiv9287773430last p span.yiv9287773430yshortcuts
{margin-right:0;}#yiv9287773430 div.yiv9287773430attach-table div div a
{text-decoration:none;}#yiv9287773430 div.yiv9287773430attach-table
{width:400px;}#yiv9287773430 div.yiv9287773430file-title a, #yiv9287773430
div.yiv9287773430file-title a:active, #yiv9287773430
div.yiv9287773430file-title a:hover, #yiv9287773430 div.yiv9287773430file-title
a:visited {text-decoration:none;}#yiv9287773430 div.yiv9287773430photo-title a,
#yiv9287773430 div.yiv9287773430photo-title a:active, #yiv9287773430
div.yiv9287773430photo-title a:hover, #yiv9287773430
div.yiv9287773430photo-title a:visited {text-decoration:none;}#yiv9287773430
div#yiv9287773430ygrp-mlmsg #yiv9287773430ygrp-msg p a
span.yiv9287773430yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9287773430
.yiv9287773430green {color:#628c2a;}#yiv9287773430 .yiv9287773430MsoNormal
{margin:0 0 0 0;}#yiv9287773430 o {font-size:0;}#yiv9287773430
#yiv9287773430photos div {float:left;width:72px;}#yiv9287773430
#yiv9287773430photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9287773430
#yiv9287773430photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9287773430
#yiv9287773430reco-category {font-size:77%;}#yiv9287773430
#yiv9287773430reco-desc {font-size:77%;}#yiv9287773430 .yiv9287773430replbq
{margin:4px;}#yiv9287773430 #yiv9287773430ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9287773430 #yiv9287773430ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9287773430
#yiv9287773430ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9287773430
#yiv9287773430ygrp-mlmsg select, #yiv9287773430 input, #yiv9287773430 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9287773430
#yiv9287773430ygrp-mlmsg pre, #yiv9287773430 code {font:115%
monospace;}#yiv9287773430 #yiv9287773430ygrp-mlmsg *
{line-height:1.22em;}#yiv9287773430 #yiv9287773430ygrp-mlmsg #yiv9287773430logo
{padding-bottom:10px;}#yiv9287773430 #yiv9287773430ygrp-msg p a
{font-family:Verdana;}#yiv9287773430 #yiv9287773430ygrp-msg
p#yiv9287773430attach-count span {color:#1E66AE;font-weight:700;}#yiv9287773430
#yiv9287773430ygrp-reco #yiv9287773430reco-head
{color:#ff7900;font-weight:700;}#yiv9287773430 #yiv9287773430ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9287773430 #yiv9287773430ygrp-sponsor
#yiv9287773430ov li a {font-size:130%;text-decoration:none;}#yiv9287773430
#yiv9287773430ygrp-sponsor #yiv9287773430ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9287773430
#yiv9287773430ygrp-sponsor #yiv9287773430ov ul {margin:0;padding:0 0 0
8px;}#yiv9287773430 #yiv9287773430ygrp-text
{font-family:Georgia;}#yiv9287773430 #yiv9287773430ygrp-text p {margin:0 0 1em
0;}#yiv9287773430 #yiv9287773430ygrp-text tt {font-size:120%;}#yiv9287773430
#yiv9287773430ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9287773430
