hai mas zainul,
saya itu malah penasaran dengan .xlsx kok bisa menyimpan macro ya...?
mohon sering ilmunya, n klo boleh itu protec macro nya di buka dunk, biar bisa
di aplikasikan di workbook lain...
terimakasih... br,
odong nando
Dari: "[email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Sabtu, 19 Agustus 2017 12:53
Judul: [belajar-excel] Terbilang Angka ke Huruf (Bahasa Inggris) tanpa Macro
[1 Attachment]
Teman2 be-exelers,
Saya iseng membuat fungsi terbilang dari angka ke huruf dalam bahasa inggris
dengan menggunakan "named range".Fungsi tersebut biasanya digunaakan saat
membuat kwitansi atau invoice.
Mohon untuk turut mengujinya barangkali ada yang salah atau ada yang berminat
untuk mengembangkan ke bahasa yang lain.
Jika penasaran ingin melihat rumus dalam "named range", gunakan macro berikut:
Sub ss()
For Each s In ThisWorkbook.Names
s.Visible = true
Next
End Sub
terimakasih,-zainul #yiv5634562016 #yiv5634562016 -- #yiv5634562016ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv5634562016 #yiv5634562016ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv5634562016 #yiv5634562016ygrp-mkp #yiv5634562016hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5634562016 #yiv5634562016ygrp-mkp #yiv5634562016ads
{margin-bottom:10px;}#yiv5634562016 #yiv5634562016ygrp-mkp .yiv5634562016ad
{padding:0 0;}#yiv5634562016 #yiv5634562016ygrp-mkp .yiv5634562016ad p
{margin:0;}#yiv5634562016 #yiv5634562016ygrp-mkp .yiv5634562016ad a
{color:#0000ff;text-decoration:none;}#yiv5634562016 #yiv5634562016ygrp-sponsor
#yiv5634562016ygrp-lc {font-family:Arial;}#yiv5634562016
#yiv5634562016ygrp-sponsor #yiv5634562016ygrp-lc #yiv5634562016hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5634562016
#yiv5634562016ygrp-sponsor #yiv5634562016ygrp-lc .yiv5634562016ad
{margin-bottom:10px;padding:0 0;}#yiv5634562016 #yiv5634562016actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5634562016
#yiv5634562016activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5634562016
#yiv5634562016activity span {font-weight:700;}#yiv5634562016
#yiv5634562016activity span:first-child
{text-transform:uppercase;}#yiv5634562016 #yiv5634562016activity span a
{color:#5085b6;text-decoration:none;}#yiv5634562016 #yiv5634562016activity span
span {color:#ff7900;}#yiv5634562016 #yiv5634562016activity span
.yiv5634562016underline {text-decoration:underline;}#yiv5634562016
.yiv5634562016attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5634562016 .yiv5634562016attach div a
{text-decoration:none;}#yiv5634562016 .yiv5634562016attach img
{border:none;padding-right:5px;}#yiv5634562016 .yiv5634562016attach label
{display:block;margin-bottom:5px;}#yiv5634562016 .yiv5634562016attach label a
{text-decoration:none;}#yiv5634562016 blockquote {margin:0 0 0
4px;}#yiv5634562016 .yiv5634562016bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5634562016
.yiv5634562016bold a {text-decoration:none;}#yiv5634562016 dd.yiv5634562016last
p a {font-family:Verdana;font-weight:700;}#yiv5634562016 dd.yiv5634562016last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5634562016
dd.yiv5634562016last p span.yiv5634562016yshortcuts
{margin-right:0;}#yiv5634562016 div.yiv5634562016attach-table div div a
{text-decoration:none;}#yiv5634562016 div.yiv5634562016attach-table
{width:400px;}#yiv5634562016 div.yiv5634562016file-title a, #yiv5634562016
div.yiv5634562016file-title a:active, #yiv5634562016
div.yiv5634562016file-title a:hover, #yiv5634562016 div.yiv5634562016file-title
a:visited {text-decoration:none;}#yiv5634562016 div.yiv5634562016photo-title a,
#yiv5634562016 div.yiv5634562016photo-title a:active, #yiv5634562016
div.yiv5634562016photo-title a:hover, #yiv5634562016
div.yiv5634562016photo-title a:visited {text-decoration:none;}#yiv5634562016
div#yiv5634562016ygrp-mlmsg #yiv5634562016ygrp-msg p a
span.yiv5634562016yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5634562016
.yiv5634562016green {color:#628c2a;}#yiv5634562016 .yiv5634562016MsoNormal
{margin:0 0 0 0;}#yiv5634562016 o {font-size:0;}#yiv5634562016
#yiv5634562016photos div {float:left;width:72px;}#yiv5634562016
#yiv5634562016photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5634562016
#yiv5634562016photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5634562016
#yiv5634562016reco-category {font-size:77%;}#yiv5634562016
#yiv5634562016reco-desc {font-size:77%;}#yiv5634562016 .yiv5634562016replbq
{margin:4px;}#yiv5634562016 #yiv5634562016ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5634562016 #yiv5634562016ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5634562016
#yiv5634562016ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5634562016
#yiv5634562016ygrp-mlmsg select, #yiv5634562016 input, #yiv5634562016 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5634562016
#yiv5634562016ygrp-mlmsg pre, #yiv5634562016 code {font:115%
monospace;}#yiv5634562016 #yiv5634562016ygrp-mlmsg *
{line-height:1.22em;}#yiv5634562016 #yiv5634562016ygrp-mlmsg #yiv5634562016logo
{padding-bottom:10px;}#yiv5634562016 #yiv5634562016ygrp-msg p a
{font-family:Verdana;}#yiv5634562016 #yiv5634562016ygrp-msg
p#yiv5634562016attach-count span {color:#1E66AE;font-weight:700;}#yiv5634562016
#yiv5634562016ygrp-reco #yiv5634562016reco-head
{color:#ff7900;font-weight:700;}#yiv5634562016 #yiv5634562016ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5634562016 #yiv5634562016ygrp-sponsor
#yiv5634562016ov li a {font-size:130%;text-decoration:none;}#yiv5634562016
#yiv5634562016ygrp-sponsor #yiv5634562016ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5634562016
#yiv5634562016ygrp-sponsor #yiv5634562016ov ul {margin:0;padding:0 0 0
8px;}#yiv5634562016 #yiv5634562016ygrp-text
{font-family:Georgia;}#yiv5634562016 #yiv5634562016ygrp-text p {margin:0 0 1em
0;}#yiv5634562016 #yiv5634562016ygrp-text tt {font-size:120%;}#yiv5634562016
#yiv5634562016ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5634562016
