Bisa di kasi contohnya..
Pada Selasa, 11 Agustus 2015 9:35, "Heru Safrudin superhe...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Betul sekali Pak Agus, tapi bisakah pakai macro dan bagaimana kodenya
?Wassalam,
Heru Safrudin
Pada 2015 8 10 16:09, "Nang Agus nanga...@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com> menulis:
Apakah yang dimaksud dengan jumlah baris dalam satu cell?
jika baris tersebut dibuat dengan menekan Alt dan Enter, maka dapat
digunakan formula :
=LEN(A4)-LEN(SUBSTITUTE(A4;CHAR(10);""))
kalau baris tersebut dibuat menggunakan warpText berarti dapat
dihitung dengan menghitung panjang teext dibagi banyak karakter setiap
baris yang masih bergantung pada ukuran font.
semoga saya tidak salah tangkap.
wasalam
KenangAgus
On 8/10/15, Heru Safrudin superhe...@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
> Dear Para Master,
>
> Bagaimanakah kode macronya untuk menghitung jumlah baris dalam SATU CELL
> yang didalamnya terdapat beberapa baris ?
>
> Mohon pemahamannya
>
> Wassalam,
>
> Heru Safrudin
> PT. BISI International, Tbk.
>
#yiv5054434016 #yiv5054434016 -- #yiv5054434016ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5054434016
#yiv5054434016ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5054434016
#yiv5054434016ygrp-mkp #yiv5054434016hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5054434016 #yiv5054434016ygrp-mkp #yiv5054434016ads
{margin-bottom:10px;}#yiv5054434016 #yiv5054434016ygrp-mkp .yiv5054434016ad
{padding:0 0;}#yiv5054434016 #yiv5054434016ygrp-mkp .yiv5054434016ad p
{margin:0;}#yiv5054434016 #yiv5054434016ygrp-mkp .yiv5054434016ad a
{color:#0000ff;text-decoration:none;}#yiv5054434016 #yiv5054434016ygrp-sponsor
#yiv5054434016ygrp-lc {font-family:Arial;}#yiv5054434016
#yiv5054434016ygrp-sponsor #yiv5054434016ygrp-lc #yiv5054434016hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5054434016
#yiv5054434016ygrp-sponsor #yiv5054434016ygrp-lc .yiv5054434016ad
{margin-bottom:10px;padding:0 0;}#yiv5054434016 #yiv5054434016actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5054434016
#yiv5054434016activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5054434016
#yiv5054434016activity span {font-weight:700;}#yiv5054434016
#yiv5054434016activity span:first-child
{text-transform:uppercase;}#yiv5054434016 #yiv5054434016activity span a
{color:#5085b6;text-decoration:none;}#yiv5054434016 #yiv5054434016activity span
span {color:#ff7900;}#yiv5054434016 #yiv5054434016activity span
.yiv5054434016underline {text-decoration:underline;}#yiv5054434016
.yiv5054434016attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5054434016 .yiv5054434016attach div a
{text-decoration:none;}#yiv5054434016 .yiv5054434016attach img
{border:none;padding-right:5px;}#yiv5054434016 .yiv5054434016attach label
{display:block;margin-bottom:5px;}#yiv5054434016 .yiv5054434016attach label a
{text-decoration:none;}#yiv5054434016 blockquote {margin:0 0 0
4px;}#yiv5054434016 .yiv5054434016bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5054434016
.yiv5054434016bold a {text-decoration:none;}#yiv5054434016 dd.yiv5054434016last
p a {font-family:Verdana;font-weight:700;}#yiv5054434016 dd.yiv5054434016last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5054434016
dd.yiv5054434016last p span.yiv5054434016yshortcuts
{margin-right:0;}#yiv5054434016 div.yiv5054434016attach-table div div a
{text-decoration:none;}#yiv5054434016 div.yiv5054434016attach-table
{width:400px;}#yiv5054434016 div.yiv5054434016file-title a, #yiv5054434016
div.yiv5054434016file-title a:active, #yiv5054434016
div.yiv5054434016file-title a:hover, #yiv5054434016 div.yiv5054434016file-title
a:visited {text-decoration:none;}#yiv5054434016 div.yiv5054434016photo-title a,
#yiv5054434016 div.yiv5054434016photo-title a:active, #yiv5054434016
div.yiv5054434016photo-title a:hover, #yiv5054434016
div.yiv5054434016photo-title a:visited {text-decoration:none;}#yiv5054434016
div#yiv5054434016ygrp-mlmsg #yiv5054434016ygrp-msg p a
span.yiv5054434016yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5054434016
.yiv5054434016green {color:#628c2a;}#yiv5054434016 .yiv5054434016MsoNormal
{margin:0 0 0 0;}#yiv5054434016 o {font-size:0;}#yiv5054434016
#yiv5054434016photos div {float:left;width:72px;}#yiv5054434016
#yiv5054434016photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5054434016
#yiv5054434016photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5054434016
#yiv5054434016reco-category {font-size:77%;}#yiv5054434016
#yiv5054434016reco-desc {font-size:77%;}#yiv5054434016 .yiv5054434016replbq
{margin:4px;}#yiv5054434016 #yiv5054434016ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5054434016 #yiv5054434016ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5054434016
#yiv5054434016ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5054434016
#yiv5054434016ygrp-mlmsg select, #yiv5054434016 input, #yiv5054434016 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5054434016
#yiv5054434016ygrp-mlmsg pre, #yiv5054434016 code {font:115%
monospace;}#yiv5054434016 #yiv5054434016ygrp-mlmsg *
{line-height:1.22em;}#yiv5054434016 #yiv5054434016ygrp-mlmsg #yiv5054434016logo
{padding-bottom:10px;}#yiv5054434016 #yiv5054434016ygrp-msg p a
{font-family:Verdana;}#yiv5054434016 #yiv5054434016ygrp-msg
p#yiv5054434016attach-count span {color:#1E66AE;font-weight:700;}#yiv5054434016
#yiv5054434016ygrp-reco #yiv5054434016reco-head
{color:#ff7900;font-weight:700;}#yiv5054434016 #yiv5054434016ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5054434016 #yiv5054434016ygrp-sponsor
#yiv5054434016ov li a {font-size:130%;text-decoration:none;}#yiv5054434016
#yiv5054434016ygrp-sponsor #yiv5054434016ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5054434016
#yiv5054434016ygrp-sponsor #yiv5054434016ov ul {margin:0;padding:0 0 0
8px;}#yiv5054434016 #yiv5054434016ygrp-text
{font-family:Georgia;}#yiv5054434016 #yiv5054434016ygrp-text p {margin:0 0 1em
0;}#yiv5054434016 #yiv5054434016ygrp-text tt {font-size:120%;}#yiv5054434016
#yiv5054434016ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5054434016
