Dear Pak Heru,
Method SendKeys ("%" dan "~") sama halnya kita menekan Alt+Enter.Menghitung
Cell yg sudah ada textnya...?Mungkin pak Heru bisa kasi contohnya dari data
yang ada ke data yang pak Heru inginkan sehingga mungkin teman2 di sini bisa
mengerti dan membantu.
TerimaKasih.
Pada Kamis, 13 Agustus 2015 11:27, "Heru Safrudin [email protected]
[belajar-excel]" <[email protected]> menulis:
Kalo pakai Sendkeys apakah artinya proses hitung barisnya ketika kita
menekan {Alt}{Enter} begitukah ?
Padahal kita mau itung cell yg udah ada teksnya Pak Toby ?Terima kasih
Wassalamu 'alaikum wr. wb.,
Heru SafrudinPada 2015 8 12 17:06, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Pak Heru,
Bisa juga manfaatkan method Application.SendKeys.
TerimaKasih.
Pada Selasa, 11 Agustus 2015 13:49, "Heru Safrudin [email protected]
[belajar-excel]" <[email protected]> menulis:
Ok benar, terima kasih banyak atas ilmunyaTerima kasih
Wassalamu 'alaikum wr. wb.,
Heru SafrudinPada 2015 8 11 12:23, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> menulis:
Asalamualaikum warahmatullah,
Sama kok pak Heru antara formula dan VBA,
Bisa dicoba cekrip begini:
Sub baris()
Range("B1") = Len(Range("A1")) - Len(Replace(Range("A1"), Chr(10), "")) + 1
End Sub
(data ada di A1, sedangkan hasilnya ditulis di B1)
Wasalamualaikum warahmatullah
On 8/11/15, Heru Safrudin [email protected] [belajar-excel]
<[email protected]> wrote:
> Iya Pak Toby, seperti yg ditanggapi Pak Agus :
> Misal di cell A1 diketik
>
> Nama:[Alt-Enter]
> Heru[Alt-Enter]
> Alamat:[Alt-Enter]
> Kediri
>
> Artinya dalan Cell A1 terdapat 4 Baris teks.
> Nah pertama saya akan menghitung baris di cell A1, kalau diketahui jumlah
> barisnya saya akan letakkan masing2 teks ke cell lain yg saya kehendaki,
> misal Baris-1 atau Nama: di cell B1, kemudian Baris-1 atau Heru di cell C1,
> dst...
>
> Wassalam,
>
> Heru Safrudin
> Pada 2015 8 11 10:16, "Toby kenzo [email protected] [belajar-excel]" <
> [email protected]> menulis:
>
>>
>>
>>
>> Bisa di kasi contohnya..
>>
>>
>>
>> Pada Selasa, 11 Agustus 2015 9:35, "Heru Safrudin [email protected]
>> [belajar-excel]" <[email protected]> menulis:
>>
>>
>>
>> Betul sekali Pak Agus, tapi bisakah pakai macro dan bagaimana kodenya ?
>> Wassalam,
>> Heru Safrudin
>> Pada 2015 8 10 16:09, "Nang Agus [email protected] [belajar-excel]" <
>> [email protected]> 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 [email protected] [belajar-excel]
>> <[email protected]> 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.
>> >
>>
>>
>>
>>
>>
>
#yiv9144018836 #yiv9144018836 -- #yiv9144018836ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9144018836
#yiv9144018836ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9144018836
#yiv9144018836ygrp-mkp #yiv9144018836hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9144018836 #yiv9144018836ygrp-mkp #yiv9144018836ads
{margin-bottom:10px;}#yiv9144018836 #yiv9144018836ygrp-mkp .yiv9144018836ad
{padding:0 0;}#yiv9144018836 #yiv9144018836ygrp-mkp .yiv9144018836ad p
{margin:0;}#yiv9144018836 #yiv9144018836ygrp-mkp .yiv9144018836ad a
{color:#0000ff;text-decoration:none;}#yiv9144018836 #yiv9144018836ygrp-sponsor
#yiv9144018836ygrp-lc {font-family:Arial;}#yiv9144018836
#yiv9144018836ygrp-sponsor #yiv9144018836ygrp-lc #yiv9144018836hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9144018836
#yiv9144018836ygrp-sponsor #yiv9144018836ygrp-lc .yiv9144018836ad
{margin-bottom:10px;padding:0 0;}#yiv9144018836 #yiv9144018836actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9144018836
#yiv9144018836activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9144018836
#yiv9144018836activity span {font-weight:700;}#yiv9144018836
#yiv9144018836activity span:first-child
{text-transform:uppercase;}#yiv9144018836 #yiv9144018836activity span a
{color:#5085b6;text-decoration:none;}#yiv9144018836 #yiv9144018836activity span
span {color:#ff7900;}#yiv9144018836 #yiv9144018836activity span
.yiv9144018836underline {text-decoration:underline;}#yiv9144018836
.yiv9144018836attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9144018836 .yiv9144018836attach div a
{text-decoration:none;}#yiv9144018836 .yiv9144018836attach img
{border:none;padding-right:5px;}#yiv9144018836 .yiv9144018836attach label
{display:block;margin-bottom:5px;}#yiv9144018836 .yiv9144018836attach label a
{text-decoration:none;}#yiv9144018836 blockquote {margin:0 0 0
4px;}#yiv9144018836 .yiv9144018836bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9144018836
.yiv9144018836bold a {text-decoration:none;}#yiv9144018836 dd.yiv9144018836last
p a {font-family:Verdana;font-weight:700;}#yiv9144018836 dd.yiv9144018836last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9144018836
dd.yiv9144018836last p span.yiv9144018836yshortcuts
{margin-right:0;}#yiv9144018836 div.yiv9144018836attach-table div div a
{text-decoration:none;}#yiv9144018836 div.yiv9144018836attach-table
{width:400px;}#yiv9144018836 div.yiv9144018836file-title a, #yiv9144018836
div.yiv9144018836file-title a:active, #yiv9144018836
div.yiv9144018836file-title a:hover, #yiv9144018836 div.yiv9144018836file-title
a:visited {text-decoration:none;}#yiv9144018836 div.yiv9144018836photo-title a,
#yiv9144018836 div.yiv9144018836photo-title a:active, #yiv9144018836
div.yiv9144018836photo-title a:hover, #yiv9144018836
div.yiv9144018836photo-title a:visited {text-decoration:none;}#yiv9144018836
div#yiv9144018836ygrp-mlmsg #yiv9144018836ygrp-msg p a
span.yiv9144018836yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9144018836
.yiv9144018836green {color:#628c2a;}#yiv9144018836 .yiv9144018836MsoNormal
{margin:0 0 0 0;}#yiv9144018836 o {font-size:0;}#yiv9144018836
#yiv9144018836photos div {float:left;width:72px;}#yiv9144018836
#yiv9144018836photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9144018836
#yiv9144018836photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9144018836
#yiv9144018836reco-category {font-size:77%;}#yiv9144018836
#yiv9144018836reco-desc {font-size:77%;}#yiv9144018836 .yiv9144018836replbq
{margin:4px;}#yiv9144018836 #yiv9144018836ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9144018836 #yiv9144018836ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9144018836
#yiv9144018836ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9144018836
#yiv9144018836ygrp-mlmsg select, #yiv9144018836 input, #yiv9144018836 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9144018836
#yiv9144018836ygrp-mlmsg pre, #yiv9144018836 code {font:115%
monospace;}#yiv9144018836 #yiv9144018836ygrp-mlmsg *
{line-height:1.22em;}#yiv9144018836 #yiv9144018836ygrp-mlmsg #yiv9144018836logo
{padding-bottom:10px;}#yiv9144018836 #yiv9144018836ygrp-msg p a
{font-family:Verdana;}#yiv9144018836 #yiv9144018836ygrp-msg
p#yiv9144018836attach-count span {color:#1E66AE;font-weight:700;}#yiv9144018836
#yiv9144018836ygrp-reco #yiv9144018836reco-head
{color:#ff7900;font-weight:700;}#yiv9144018836 #yiv9144018836ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9144018836 #yiv9144018836ygrp-sponsor
#yiv9144018836ov li a {font-size:130%;text-decoration:none;}#yiv9144018836
#yiv9144018836ygrp-sponsor #yiv9144018836ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9144018836
#yiv9144018836ygrp-sponsor #yiv9144018836ov ul {margin:0;padding:0 0 0
8px;}#yiv9144018836 #yiv9144018836ygrp-text
{font-family:Georgia;}#yiv9144018836 #yiv9144018836ygrp-text p {margin:0 0 1em
0;}#yiv9144018836 #yiv9144018836ygrp-text tt {font-size:120%;}#yiv9144018836
#yiv9144018836ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9144018836
