terima kasih atas penjelasan nang agus, soale baru coba2 belajar VBA. jadi
masih baca2 coding dulu.
On Tuesday, October 7, 2014 1:38 AM, "fatimah nazmy [email protected]
[belajar-excel]" <[email protected]> wrote:
file terlampirnya kelupaan......
On Monday, October 6, 2014 9:17 PM, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> wrote:
Asalamualaikum warahmatullah,
mbak Fatimah,
Mohon denga hormat untuk kesempatan lain, apabila mengirimkan file yang berisi
UDF atau VBA menggunakan file bereksistensi *.XLSM atau *.XLB jangan
menggunakan *.XLSX seperti yang disertakan dalam email ini.
JIka menggunakan *.XLSX maka UDF atau VBA yang ada pada file akan hilang. Jadi
file yang anda kirimkan dengan UDF, tidak ada UDFnya.
Karena file yang dikirimkan tidak ada UDFnya, tentunya member B-Excel tidak
dapat menanggapi (membantu) untuk menyelesaikan masalah, Kecuali yang sudah
mempunyai file asal.
Apakah seperti lampiran yang dimaksud?
Wasalam
NangAgus
2014-10-06 18:02 GMT+11:00 fatimah nazmy [email protected] [belajar-excel]
<[email protected]>:
Assalamu 'alaikum Wr.Wb.
nyontek rumus mr kid di file combine.txt (karena keterbatasan jadi belum bisa
memahamialur rumusnya) jadi cobautak atik buat rumus sendiri ternyata blum jg
berhasil malah eror. mohon bantuan rekan2 milis atas masalah ini. file terlampir
On Sunday, October 5, 2014 11:57 PM, fatimah nazmy wrote:
#yiv3219724945 #yiv3219724945 -- #yiv3219724945ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3219724945
#yiv3219724945ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3219724945
#yiv3219724945ygrp-mkp #yiv3219724945hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3219724945 #yiv3219724945ygrp-mkp #yiv3219724945ads
{margin-bottom:10px;}#yiv3219724945 #yiv3219724945ygrp-mkp .yiv3219724945ad
{padding:0 0;}#yiv3219724945 #yiv3219724945ygrp-mkp .yiv3219724945ad p
{margin:0;}#yiv3219724945 #yiv3219724945ygrp-mkp .yiv3219724945ad a
{color:#0000ff;text-decoration:none;}#yiv3219724945 #yiv3219724945ygrp-sponsor
#yiv3219724945ygrp-lc {font-family:Arial;}#yiv3219724945
#yiv3219724945ygrp-sponsor #yiv3219724945ygrp-lc #yiv3219724945hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3219724945
#yiv3219724945ygrp-sponsor #yiv3219724945ygrp-lc .yiv3219724945ad
{margin-bottom:10px;padding:0 0;}#yiv3219724945 #yiv3219724945actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3219724945
#yiv3219724945activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3219724945
#yiv3219724945activity span {font-weight:700;}#yiv3219724945
#yiv3219724945activity span:first-child
{text-transform:uppercase;}#yiv3219724945 #yiv3219724945activity span a
{color:#5085b6;text-decoration:none;}#yiv3219724945 #yiv3219724945activity span
span {color:#ff7900;}#yiv3219724945 #yiv3219724945activity span
.yiv3219724945underline {text-decoration:underline;}#yiv3219724945
.yiv3219724945attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3219724945 .yiv3219724945attach div a
{text-decoration:none;}#yiv3219724945 .yiv3219724945attach img
{border:none;padding-right:5px;}#yiv3219724945 .yiv3219724945attach label
{display:block;margin-bottom:5px;}#yiv3219724945 .yiv3219724945attach label a
{text-decoration:none;}#yiv3219724945 blockquote {margin:0 0 0
4px;}#yiv3219724945 .yiv3219724945bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3219724945
.yiv3219724945bold a {text-decoration:none;}#yiv3219724945 dd.yiv3219724945last
p a {font-family:Verdana;font-weight:700;}#yiv3219724945 dd.yiv3219724945last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3219724945
dd.yiv3219724945last p span.yiv3219724945yshortcuts
{margin-right:0;}#yiv3219724945 div.yiv3219724945attach-table div div a
{text-decoration:none;}#yiv3219724945 div.yiv3219724945attach-table
{width:400px;}#yiv3219724945 div.yiv3219724945file-title a, #yiv3219724945
div.yiv3219724945file-title a:active, #yiv3219724945
div.yiv3219724945file-title a:hover, #yiv3219724945 div.yiv3219724945file-title
a:visited {text-decoration:none;}#yiv3219724945 div.yiv3219724945photo-title a,
#yiv3219724945 div.yiv3219724945photo-title a:active, #yiv3219724945
div.yiv3219724945photo-title a:hover, #yiv3219724945
div.yiv3219724945photo-title a:visited {text-decoration:none;}#yiv3219724945
div#yiv3219724945ygrp-mlmsg #yiv3219724945ygrp-msg p a
span.yiv3219724945yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3219724945
.yiv3219724945green {color:#628c2a;}#yiv3219724945 .yiv3219724945MsoNormal
{margin:0 0 0 0;}#yiv3219724945 o {font-size:0;}#yiv3219724945
#yiv3219724945photos div {float:left;width:72px;}#yiv3219724945
#yiv3219724945photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3219724945
#yiv3219724945photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3219724945
#yiv3219724945reco-category {font-size:77%;}#yiv3219724945
#yiv3219724945reco-desc {font-size:77%;}#yiv3219724945 .yiv3219724945replbq
{margin:4px;}#yiv3219724945 #yiv3219724945ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3219724945 #yiv3219724945ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3219724945
#yiv3219724945ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3219724945
#yiv3219724945ygrp-mlmsg select, #yiv3219724945 input, #yiv3219724945 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3219724945
#yiv3219724945ygrp-mlmsg pre, #yiv3219724945 code {font:115%
monospace;}#yiv3219724945 #yiv3219724945ygrp-mlmsg *
{line-height:1.22em;}#yiv3219724945 #yiv3219724945ygrp-mlmsg #yiv3219724945logo
{padding-bottom:10px;}#yiv3219724945 #yiv3219724945ygrp-msg p a
{font-family:Verdana;}#yiv3219724945 #yiv3219724945ygrp-msg
p#yiv3219724945attach-count span {color:#1E66AE;font-weight:700;}#yiv3219724945
#yiv3219724945ygrp-reco #yiv3219724945reco-head
{color:#ff7900;font-weight:700;}#yiv3219724945 #yiv3219724945ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3219724945 #yiv3219724945ygrp-sponsor
#yiv3219724945ov li a {font-size:130%;text-decoration:none;}#yiv3219724945
#yiv3219724945ygrp-sponsor #yiv3219724945ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3219724945
#yiv3219724945ygrp-sponsor #yiv3219724945ov ul {margin:0;padding:0 0 0
8px;}#yiv3219724945 #yiv3219724945ygrp-text
{font-family:Georgia;}#yiv3219724945 #yiv3219724945ygrp-text p {margin:0 0 1em
0;}#yiv3219724945 #yiv3219724945ygrp-text tt {font-size:120%;}#yiv3219724945
#yiv3219724945ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3219724945
