Pak Toby,
Sudah saya enable macronya tetapi kenapa pada tombol start tidak ada icon
gambarnya atau tidak bisa di klik.
Wassalam,Samsudin
Pada Minggu, 12 Juni 2016 8:37, "Toby kenzo tobyke...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
| Sudah di aktifkan macro enablednya...Sent from Yahoo Mail on Android |
From: Samsudin Sam samsudinort...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: Bls: [belajar-excel] Code Status
Sent: Sat, Jun 11, 2016 11:48:57 PM
| Pak Toby,
Terima kasih atas pencerahannya mohon maaf setelah saya file tersebut tidak
bisa/belum khususnya pada tombol start atau delete nya.
WassalamSamsudin
Pada Minggu, 12 Juni 2016 0:09, "Toby kenzo tobyke...@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Samsudin,
Berikut saya berikan contohnya.Intinya sama saja, dengan menggunakan VBA maupun
formula Excel, karena contoh yang saya berikan intinya menggunakan formula
Excel tetapi dengan sedikit "Sentuhan" VBA.
Jika kita menggunakan formula Excel, kita akan menambahkan Row sebanyak jumlah
karakter koma (,) sesuai pada cell yang terdapat kata2 (Status)dan untuk
menghitung jumlah status bisa menggunakan formula countif dengan menambahkan
"Wild card" atau tanda * pada nilai rujukannya, misal : =
countif($C$3:$C$33,"*ABS*")
TerimaKasih.
Pada Sabtu, 11 Juni 2016 7:46, "Samsudin Sam samsudinort...@yahoo.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Assalamu'alaikum
Master Excel,
Mohon bantuan dan pencerahan untuk masalah code status.
Sebelumnya saya mengucapkan terima kasih atas pencerahannya.
Wassalam
Samsudin
|
#yiv4259294365 #yiv4259294365 -- #yiv4259294365ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4259294365
#yiv4259294365ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4259294365
#yiv4259294365ygrp-mkp #yiv4259294365hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4259294365 #yiv4259294365ygrp-mkp #yiv4259294365ads
{margin-bottom:10px;}#yiv4259294365 #yiv4259294365ygrp-mkp .yiv4259294365ad
{padding:0 0;}#yiv4259294365 #yiv4259294365ygrp-mkp .yiv4259294365ad p
{margin:0;}#yiv4259294365 #yiv4259294365ygrp-mkp .yiv4259294365ad a
{color:#0000ff;text-decoration:none;}#yiv4259294365 #yiv4259294365ygrp-sponsor
#yiv4259294365ygrp-lc {font-family:Arial;}#yiv4259294365
#yiv4259294365ygrp-sponsor #yiv4259294365ygrp-lc #yiv4259294365hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4259294365
#yiv4259294365ygrp-sponsor #yiv4259294365ygrp-lc .yiv4259294365ad
{margin-bottom:10px;padding:0 0;}#yiv4259294365 #yiv4259294365actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4259294365
#yiv4259294365activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4259294365
#yiv4259294365activity span {font-weight:700;}#yiv4259294365
#yiv4259294365activity span:first-child
{text-transform:uppercase;}#yiv4259294365 #yiv4259294365activity span a
{color:#5085b6;text-decoration:none;}#yiv4259294365 #yiv4259294365activity span
span {color:#ff7900;}#yiv4259294365 #yiv4259294365activity span
.yiv4259294365underline {text-decoration:underline;}#yiv4259294365
.yiv4259294365attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4259294365 .yiv4259294365attach div a
{text-decoration:none;}#yiv4259294365 .yiv4259294365attach img
{border:none;padding-right:5px;}#yiv4259294365 .yiv4259294365attach label
{display:block;margin-bottom:5px;}#yiv4259294365 .yiv4259294365attach label a
{text-decoration:none;}#yiv4259294365 blockquote {margin:0 0 0
4px;}#yiv4259294365 .yiv4259294365bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4259294365
.yiv4259294365bold a {text-decoration:none;}#yiv4259294365 dd.yiv4259294365last
p a {font-family:Verdana;font-weight:700;}#yiv4259294365 dd.yiv4259294365last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4259294365
dd.yiv4259294365last p span.yiv4259294365yshortcuts
{margin-right:0;}#yiv4259294365 div.yiv4259294365attach-table div div a
{text-decoration:none;}#yiv4259294365 div.yiv4259294365attach-table
{width:400px;}#yiv4259294365 div.yiv4259294365file-title a, #yiv4259294365
div.yiv4259294365file-title a:active, #yiv4259294365
div.yiv4259294365file-title a:hover, #yiv4259294365 div.yiv4259294365file-title
a:visited {text-decoration:none;}#yiv4259294365 div.yiv4259294365photo-title a,
#yiv4259294365 div.yiv4259294365photo-title a:active, #yiv4259294365
div.yiv4259294365photo-title a:hover, #yiv4259294365
div.yiv4259294365photo-title a:visited {text-decoration:none;}#yiv4259294365
div#yiv4259294365ygrp-mlmsg #yiv4259294365ygrp-msg p a
span.yiv4259294365yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4259294365
.yiv4259294365green {color:#628c2a;}#yiv4259294365 .yiv4259294365MsoNormal
{margin:0 0 0 0;}#yiv4259294365 o {font-size:0;}#yiv4259294365
#yiv4259294365photos div {float:left;width:72px;}#yiv4259294365
#yiv4259294365photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4259294365
#yiv4259294365photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4259294365
#yiv4259294365reco-category {font-size:77%;}#yiv4259294365
#yiv4259294365reco-desc {font-size:77%;}#yiv4259294365 .yiv4259294365replbq
{margin:4px;}#yiv4259294365 #yiv4259294365ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4259294365 #yiv4259294365ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4259294365
#yiv4259294365ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4259294365
#yiv4259294365ygrp-mlmsg select, #yiv4259294365 input, #yiv4259294365 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4259294365
#yiv4259294365ygrp-mlmsg pre, #yiv4259294365 code {font:115%
monospace;}#yiv4259294365 #yiv4259294365ygrp-mlmsg *
{line-height:1.22em;}#yiv4259294365 #yiv4259294365ygrp-mlmsg #yiv4259294365logo
{padding-bottom:10px;}#yiv4259294365 #yiv4259294365ygrp-msg p a
{font-family:Verdana;}#yiv4259294365 #yiv4259294365ygrp-msg
p#yiv4259294365attach-count span {color:#1E66AE;font-weight:700;}#yiv4259294365
#yiv4259294365ygrp-reco #yiv4259294365reco-head
{color:#ff7900;font-weight:700;}#yiv4259294365 #yiv4259294365ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4259294365 #yiv4259294365ygrp-sponsor
#yiv4259294365ov li a {font-size:130%;text-decoration:none;}#yiv4259294365
#yiv4259294365ygrp-sponsor #yiv4259294365ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4259294365
#yiv4259294365ygrp-sponsor #yiv4259294365ov ul {margin:0;padding:0 0 0
8px;}#yiv4259294365 #yiv4259294365ygrp-text
{font-family:Georgia;}#yiv4259294365 #yiv4259294365ygrp-text p {margin:0 0 1em
0;}#yiv4259294365 #yiv4259294365ygrp-text tt {font-size:120%;}#yiv4259294365
#yiv4259294365ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4259294365
