Trima kasih Master.....kalo misal dipindah ke cell lain, berarti tinggal diedit
address sama range nya yg di visual basicnya ya...
Pada Senin, 3 Oktober 2016 17:18, "odong nando [email protected]
[belajar-excel]" <[email protected]> menulis:
jgn lupa turn on macro na yak, posisinya aga di ubah dikit br,
odong nando
Dari: "aza_faza [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Senin, 3 Oktober 2016 16:33
Judul: [belajar-excel] Help : Apakah tinggi Row bisa diatur pakai formula
Dear para Master Excel,
Apakah bisa suatu row itu diatur tingginya dengan formula..karena saya mau
bikin surat memakai excel, namun tampilan kurang bagus karena ada spasi tabel
yang berisi data kosong.
Untuk lebih jelasnya bisa dilihat di aatachment
Terima kasih
Dikirim dari ponsel cerdas Samsung Galaxy saya.
#yiv1441915851 #yiv1441915851 -- #yiv1441915851ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1441915851
#yiv1441915851ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1441915851
#yiv1441915851ygrp-mkp #yiv1441915851hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1441915851 #yiv1441915851ygrp-mkp #yiv1441915851ads
{margin-bottom:10px;}#yiv1441915851 #yiv1441915851ygrp-mkp .yiv1441915851ad
{padding:0 0;}#yiv1441915851 #yiv1441915851ygrp-mkp .yiv1441915851ad p
{margin:0;}#yiv1441915851 #yiv1441915851ygrp-mkp .yiv1441915851ad a
{color:#0000ff;text-decoration:none;}#yiv1441915851 #yiv1441915851ygrp-sponsor
#yiv1441915851ygrp-lc {font-family:Arial;}#yiv1441915851
#yiv1441915851ygrp-sponsor #yiv1441915851ygrp-lc #yiv1441915851hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1441915851
#yiv1441915851ygrp-sponsor #yiv1441915851ygrp-lc .yiv1441915851ad
{margin-bottom:10px;padding:0 0;}#yiv1441915851 #yiv1441915851actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1441915851
#yiv1441915851activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1441915851
#yiv1441915851activity span {font-weight:700;}#yiv1441915851
#yiv1441915851activity span:first-child
{text-transform:uppercase;}#yiv1441915851 #yiv1441915851activity span a
{color:#5085b6;text-decoration:none;}#yiv1441915851 #yiv1441915851activity span
span {color:#ff7900;}#yiv1441915851 #yiv1441915851activity span
.yiv1441915851underline {text-decoration:underline;}#yiv1441915851
.yiv1441915851attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1441915851 .yiv1441915851attach div a
{text-decoration:none;}#yiv1441915851 .yiv1441915851attach img
{border:none;padding-right:5px;}#yiv1441915851 .yiv1441915851attach label
{display:block;margin-bottom:5px;}#yiv1441915851 .yiv1441915851attach label a
{text-decoration:none;}#yiv1441915851 blockquote {margin:0 0 0
4px;}#yiv1441915851 .yiv1441915851bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1441915851
.yiv1441915851bold a {text-decoration:none;}#yiv1441915851 dd.yiv1441915851last
p a {font-family:Verdana;font-weight:700;}#yiv1441915851 dd.yiv1441915851last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1441915851
dd.yiv1441915851last p span.yiv1441915851yshortcuts
{margin-right:0;}#yiv1441915851 div.yiv1441915851attach-table div div a
{text-decoration:none;}#yiv1441915851 div.yiv1441915851attach-table
{width:400px;}#yiv1441915851 div.yiv1441915851file-title a, #yiv1441915851
div.yiv1441915851file-title a:active, #yiv1441915851
div.yiv1441915851file-title a:hover, #yiv1441915851 div.yiv1441915851file-title
a:visited {text-decoration:none;}#yiv1441915851 div.yiv1441915851photo-title a,
#yiv1441915851 div.yiv1441915851photo-title a:active, #yiv1441915851
div.yiv1441915851photo-title a:hover, #yiv1441915851
div.yiv1441915851photo-title a:visited {text-decoration:none;}#yiv1441915851
div#yiv1441915851ygrp-mlmsg #yiv1441915851ygrp-msg p a
span.yiv1441915851yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1441915851
.yiv1441915851green {color:#628c2a;}#yiv1441915851 .yiv1441915851MsoNormal
{margin:0 0 0 0;}#yiv1441915851 o {font-size:0;}#yiv1441915851
#yiv1441915851photos div {float:left;width:72px;}#yiv1441915851
#yiv1441915851photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1441915851
#yiv1441915851photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1441915851
#yiv1441915851reco-category {font-size:77%;}#yiv1441915851
#yiv1441915851reco-desc {font-size:77%;}#yiv1441915851 .yiv1441915851replbq
{margin:4px;}#yiv1441915851 #yiv1441915851ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1441915851 #yiv1441915851ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1441915851
#yiv1441915851ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1441915851
#yiv1441915851ygrp-mlmsg select, #yiv1441915851 input, #yiv1441915851 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1441915851
#yiv1441915851ygrp-mlmsg pre, #yiv1441915851 code {font:115%
monospace;}#yiv1441915851 #yiv1441915851ygrp-mlmsg *
{line-height:1.22em;}#yiv1441915851 #yiv1441915851ygrp-mlmsg #yiv1441915851logo
{padding-bottom:10px;}#yiv1441915851 #yiv1441915851ygrp-msg p a
{font-family:Verdana;}#yiv1441915851 #yiv1441915851ygrp-msg
p#yiv1441915851attach-count span {color:#1E66AE;font-weight:700;}#yiv1441915851
#yiv1441915851ygrp-reco #yiv1441915851reco-head
{color:#ff7900;font-weight:700;}#yiv1441915851 #yiv1441915851ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1441915851 #yiv1441915851ygrp-sponsor
#yiv1441915851ov li a {font-size:130%;text-decoration:none;}#yiv1441915851
#yiv1441915851ygrp-sponsor #yiv1441915851ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1441915851
#yiv1441915851ygrp-sponsor #yiv1441915851ov ul {margin:0;padding:0 0 0
8px;}#yiv1441915851 #yiv1441915851ygrp-text
{font-family:Georgia;}#yiv1441915851 #yiv1441915851ygrp-text p {margin:0 0 1em
0;}#yiv1441915851 #yiv1441915851ygrp-text tt {font-size:120%;}#yiv1441915851
#yiv1441915851ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1441915851