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 

   

Kirim email ke