[belajar-excel] Digest Number 3686

Milis Belajar Microsoft Excel Group

7 Messages

Digest #3686

1a

Re: Fungsi Dan Kegunaan Array Dua Dimensi / Multidimensi by hr_adhi

2a

Gridline by "Tio Adi Bayu Adjie"

2b

Re: Gridline by "hendrik karnadi" hendrikkarnadi

2c

Re: Gridline [1 Attachment] by "Tio Adi Bayu Adjie"

2d

Bls: [belajar-excel] Gridline by "odong nando"

3a

Re: konversi dari desimal ke format menit atau jam by agungraziqi

4a

Re: Bls: [belajar-excel] konversi dari desimal ke format menit atau by agungraziqi

Messages

1a

Re: Fungsi Dan Kegunaan Array Dua Dimensi / Multidimensi

Wed Dec 16, 2015 6:54 am (PST) . Posted by:

hr_adhi

Sebelumnya terimakasih banyak atas jawaban dari mas zainul dan mas widodo , kalau boleh apakah ada contoh file / aplikasi yg dilengkapi code terkait array dua dimensi ini , agar bisa menjadi bahan analisa saya untuk memahaminya.
Saya sudah check file dari mas zainul tetapi dalam file tersebut tidak terdapat contoh code nya.
Sekali lagi saya ucapkan terimakasih banyak atas jawaban dari mas zainul dan mas widodo sebelumnya, semoga ilmu rekan2 berkah :)
Saya tunggu jawaban dari rekan :)

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2a

Gridline

Wed Dec 16, 2015 7:20 pm (PST) . Posted by:

"Tio Adi Bayu Adjie"

Dear XL expert,
Maaf mau nanya. Untuk masalah excel dibawah.
[cid:image001.jpg@01D138B2.3A3B6440]

Terima kasih sekali atas jawabannya. Semoga Tuhan YME membalas kebaikannya.

Regards,
Tio

Reply to sender . Reply to group . Reply via Web Post . All Messages (18) . Top ^

2b

Re: Gridline

Wed Dec 16, 2015 8:01 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Tio,

Setahu saya itu adalah "Freeze Pane" mealalu menu View.Untuk menghilangkannya cukup "Unfreeze Pane", ga perlu VBA.

Salam,HK

From: "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 17 December 2015, 10:10
Subject: [belajar-excel] Gridline

  Dear XL expert, Maaf mau nanya. Untuk masalah excel dibawah.   Terima kasih sekali atas jawabannya. Semoga Tuhan YME membalas kebaikannya.   Regards, Tio     #yiv2919973231 #yiv2919973231 -- #yiv2919973231ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2919973231 #yiv2919973231ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2919973231 #yiv2919973231ygrp-mkp #yiv2919973231hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2919973231 #yiv2919973231ygrp-mkp #yiv2919973231ads {margin-bottom:10px;}#yiv2919973231 #yiv2919973231ygrp-mkp .yiv2919973231ad {padding:0 0;}#yiv2919973231 #yiv2919973231ygrp-mkp .yiv2919973231ad p {margin:0;}#yiv2919973231 #yiv2919973231ygrp-mkp .yiv2919973231ad a {color:#0000ff;text-decoration:none;}#yiv2919973231 #yiv2919973231ygrp-sponsor #yiv2919973231ygrp-lc {font-family:Arial;}#yiv2919973231 #yiv2919973231ygrp-sponsor #yiv2919973231ygrp-lc #yiv2919973231hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2919973231 #yiv2919973231ygrp-sponsor #yiv2919973231ygrp-lc .yiv2919973231ad {margin-bottom:10px;padding:0 0;}#yiv2919973231 #yiv2919973231actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2919973231 #yiv2919973231activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2919973231 #yiv2919973231activity span {font-weight:700;}#yiv2919973231 #yiv2919973231activity span:first-child {text-transform:uppercase;}#yiv2919973231 #yiv2919973231activity span a {color:#5085b6;text-decoration:none;}#yiv2919973231 #yiv2919973231activity span span {color:#ff7900;}#yiv2919973231 #yiv2919973231activity span .yiv2919973231underline {text-decoration:underline;}#yiv2919973231 .yiv2919973231attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2919973231 .yiv2919973231attach div a {text-decoration:none;}#yiv2919973231 .yiv2919973231attach img {border:none;padding-right:5px;}#yiv2919973231 .yiv2919973231attach label {display:block;margin-bottom:5px;}#yiv2919973231 .yiv2919973231attach label a {text-decoration:none;}#yiv2919973231 blockquote {margin:0 0 0 4px;}#yiv2919973231 .yiv2919973231bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2919973231 .yiv2919973231bold a {text-decoration:none;}#yiv2919973231 dd.yiv2919973231last p a {font-family:Verdana;font-weight:700;}#yiv2919973231 dd.yiv2919973231last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2919973231 dd.yiv2919973231last p span.yiv2919973231yshortcuts {margin-right:0;}#yiv2919973231 div.yiv2919973231attach-table div div a {text-decoration:none;}#yiv2919973231 div.yiv2919973231attach-table {width:400px;}#yiv2919973231 div.yiv2919973231file-title a, #yiv2919973231 div.yiv2919973231file-title a:active, #yiv2919973231 div.yiv2919973231file-title a:hover, #yiv2919973231 div.yiv2919973231file-title a:visited {text-decoration:none;}#yiv2919973231 div.yiv2919973231photo-title a, #yiv2919973231 div.yiv2919973231photo-title a:active, #yiv2919973231 div.yiv2919973231photo-title a:hover, #yiv2919973231 div.yiv2919973231photo-title a:visited {text-decoration:none;}#yiv2919973231 div#yiv2919973231ygrp-mlmsg #yiv2919973231ygrp-msg p a span.yiv2919973231yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2919973231 .yiv2919973231green {color:#628c2a;}#yiv2919973231 .yiv2919973231MsoNormal {margin:0 0 0 0;}#yiv2919973231 o {font-size:0;}#yiv2919973231 #yiv2919973231photos div {float:left;width:72px;}#yiv2919973231 #yiv2919973231photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2919973231 #yiv2919973231photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2919973231 #yiv2919973231reco-category {font-size:77%;}#yiv2919973231 #yiv2919973231reco-desc {font-size:77%;}#yiv2919973231 .yiv2919973231replbq {margin:4px;}#yiv2919973231 #yiv2919973231ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2919973231 #yiv2919973231ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2919973231 #yiv2919973231ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2919973231 #yiv2919973231ygrp-mlmsg select, #yiv2919973231 input, #yiv2919973231 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2919973231 #yiv2919973231ygrp-mlmsg pre, #yiv2919973231 code {font:115% monospace;}#yiv2919973231 #yiv2919973231ygrp-mlmsg * {line-height:1.22em;}#yiv2919973231 #yiv2919973231ygrp-mlmsg #yiv2919973231logo {padding-bottom:10px;}#yiv2919973231 #yiv2919973231ygrp-msg p a {font-family:Verdana;}#yiv2919973231 #yiv2919973231ygrp-msg p#yiv2919973231attach-count span {color:#1E66AE;font-weight:700;}#yiv2919973231 #yiv2919973231ygrp-reco #yiv2919973231reco-head {color:#ff7900;font-weight:700;}#yiv2919973231 #yiv2919973231ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2919973231 #yiv2919973231ygrp-sponsor #yiv2919973231ov li a {font-size:130%;text-decoration:none;}#yiv2919973231 #yiv2919973231ygrp-sponsor #yiv2919973231ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2919973231 #yiv2919973231ygrp-sponsor #yiv2919973231ov ul {margin:0;padding:0 0 0 8px;}#yiv2919973231 #yiv2919973231ygrp-text {font-family:Georgia;}#yiv2919973231 #yiv2919973231ygrp-text p {margin:0 0 1em 0;}#yiv2919973231 #yiv2919973231ygrp-text tt {font-size:120%;}#yiv2919973231 #yiv2919973231ygrp-vital ul li:last-child {border-right:none !important;}#yiv2919973231

Reply to sender . Reply to group . Reply via Web Post . All Messages (18) . Top ^

2c

Re: Gridline [1 Attachment]

Thu Dec 17, 2015 12:04 am (PST) . Posted by:

"Tio Adi Bayu Adjie"

Bang Hendrik,
Maaf Bang, saya tidak pakai freeze pane, itu sudah saya lihat. Sebelumnya saya pikir itu page break atau print area tapi setelah saya "clear" kan, ternyata tidak berpengaruh. Kira2 apa ya master ?

Terima kasih.

Best Regards,
Tio Adi Bayu Adjie





From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, December 17, 2015 10:58 AM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Gridline [1 Attachment]


Hai Tio,

Setahu saya itu adalah "Freeze Pane" mealalu menu View.
Untuk menghilangkannya cukup "Unfreeze Pane", ga perlu VBA.


Salam,
HK
________________________________
From: "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id<mailto:tio.adjie@ptssb.co.id> [belajar-excel]" <belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>>
To: belajar-excel@yahoogroups.com<mailto:belajar-excel@yahoogroups.com>
Sent: Thursday, 17 December 2015, 10:10
Subject: [belajar-excel] Gridline


Dear XL expert,
Maaf mau nanya. Untuk masalah excel dibawah.
[cid:image001.jpg@01D138BD.B7476960]

Terima kasih sekali atas jawabannya. Semoga Tuhan YME membalas kebaikannya.

Regards,
Tio

Reply to sender . Reply to group . Reply via Web Post . All Messages (18) . Top ^

2d

Bls: [belajar-excel] Gridline

Thu Dec 17, 2015 1:44 am (PST) . Posted by:

"odong nando"

yoo tio,
sepanjang pengetahuan saya itu adalah garis margin, akan muncul setelah kita masuk print preview, dan saat keluar dari print preview maka munculah garis tersebut. dimana garis margin tersebut adalah batas ahir suatu halaman baik atas bawah or kiri kanan. dan sifatnya tidak akan hilang kecuali kita tutup file dan keluar dari excel dan membukanya kembali tanpa melakukan print priview. br,

odong nando


Pada Kamis, 17 Desember 2015 15:04, "Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Bang Hendrik, Maaf Bang, saya tidak pakai freeze pane, itu sudah saya lihat. Sebelumnya saya pikir itu page break atau print area tapi setelah saya "clear" kan, ternyata tidak berpengaruh. Kira2 apa ya master ?   Terima kasih.  
| Best Regards, Tio Adi Bayu Adjie | |
| | | |
| | | | |

    From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, December 17, 2015 10:58 AM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Gridline [1 Attachment]     Hai Tio,   Setahu saya itu adalah "Freeze Pane" mealalu menu View. Untuk menghilangkannya cukup "Unfreeze Pane", ga perlu VBA.     Salam, HK From: "Tio Adi Bayu Adjietio.adjie@ptssb.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Thursday, 17 December 2015, 10:10
Subject: [belajar-excel] Gridline     Dear XL expert, Maaf mau nanya. Untuk masalah excel dibawah.   Terima kasih sekali atas jawabannya. Semoga Tuhan YME membalas kebaikannya.   Regards, Tio       #yiv6209865097 #yiv6209865097 -- #yiv6209865097ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6209865097 #yiv6209865097ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6209865097 #yiv6209865097ygrp-mkp #yiv6209865097hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6209865097 #yiv6209865097ygrp-mkp #yiv6209865097ads {margin-bottom:10px;}#yiv6209865097 #yiv6209865097ygrp-mkp .yiv6209865097ad {padding:0 0;}#yiv6209865097 #yiv6209865097ygrp-mkp .yiv6209865097ad p {margin:0;}#yiv6209865097 #yiv6209865097ygrp-mkp .yiv6209865097ad a {color:#0000ff;text-decoration:none;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ygrp-lc {font-family:Arial;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ygrp-lc #yiv6209865097hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ygrp-lc .yiv6209865097ad {margin-bottom:10px;padding:0 0;}#yiv6209865097 #yiv6209865097actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6209865097 #yiv6209865097activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6209865097 #yiv6209865097activity span {font-weight:700;}#yiv6209865097 #yiv6209865097activity span:first-child {text-transform:uppercase;}#yiv6209865097 #yiv6209865097activity span a {color:#5085b6;text-decoration:none;}#yiv6209865097 #yiv6209865097activity span span {color:#ff7900;}#yiv6209865097 #yiv6209865097activity span .yiv6209865097underline {text-decoration:underline;}#yiv6209865097 .yiv6209865097attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6209865097 .yiv6209865097attach div a {text-decoration:none;}#yiv6209865097 .yiv6209865097attach img {border:none;padding-right:5px;}#yiv6209865097 .yiv6209865097attach label {display:block;margin-bottom:5px;}#yiv6209865097 .yiv6209865097attach label a {text-decoration:none;}#yiv6209865097 blockquote {margin:0 0 0 4px;}#yiv6209865097 .yiv6209865097bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6209865097 .yiv6209865097bold a {text-decoration:none;}#yiv6209865097 dd.yiv6209865097last p a {font-family:Verdana;font-weight:700;}#yiv6209865097 dd.yiv6209865097last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6209865097 dd.yiv6209865097last p span.yiv6209865097yshortcuts {margin-right:0;}#yiv6209865097 div.yiv6209865097attach-table div div a {text-decoration:none;}#yiv6209865097 div.yiv6209865097attach-table {width:400px;}#yiv6209865097 div.yiv6209865097file-title a, #yiv6209865097 div.yiv6209865097file-title a:active, #yiv6209865097 div.yiv6209865097file-title a:hover, #yiv6209865097 div.yiv6209865097file-title a:visited {text-decoration:none;}#yiv6209865097 div.yiv6209865097photo-title a, #yiv6209865097 div.yiv6209865097photo-title a:active, #yiv6209865097 div.yiv6209865097photo-title a:hover, #yiv6209865097 div.yiv6209865097photo-title a:visited {text-decoration:none;}#yiv6209865097 div#yiv6209865097ygrp-mlmsg #yiv6209865097ygrp-msg p a span.yiv6209865097yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6209865097 .yiv6209865097green {color:#628c2a;}#yiv6209865097 .yiv6209865097MsoNormal {margin:0 0 0 0;}#yiv6209865097 o {font-size:0;}#yiv6209865097 #yiv6209865097photos div {float:left;width:72px;}#yiv6209865097 #yiv6209865097photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6209865097 #yiv6209865097photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6209865097 #yiv6209865097reco-category {font-size:77%;}#yiv6209865097 #yiv6209865097reco-desc {font-size:77%;}#yiv6209865097 .yiv6209865097replbq {margin:4px;}#yiv6209865097 #yiv6209865097ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6209865097 #yiv6209865097ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6209865097 #yiv6209865097ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6209865097 #yiv6209865097ygrp-mlmsg select, #yiv6209865097 input, #yiv6209865097 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6209865097 #yiv6209865097ygrp-mlmsg pre, #yiv6209865097 code {font:115% monospace;}#yiv6209865097 #yiv6209865097ygrp-mlmsg * {line-height:1.22em;}#yiv6209865097 #yiv6209865097ygrp-mlmsg #yiv6209865097logo {padding-bottom:10px;}#yiv6209865097 #yiv6209865097ygrp-msg p a {font-family:Verdana;}#yiv6209865097 #yiv6209865097ygrp-msg p#yiv6209865097attach-count span {color:#1E66AE;font-weight:700;}#yiv6209865097 #yiv6209865097ygrp-reco #yiv6209865097reco-head {color:#ff7900;font-weight:700;}#yiv6209865097 #yiv6209865097ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ov li a {font-size:130%;text-decoration:none;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6209865097 #yiv6209865097ygrp-sponsor #yiv6209865097ov ul {margin:0;padding:0 0 0 8px;}#yiv6209865097 #yiv6209865097ygrp-text {font-family:Georgia;}#yiv6209865097 #yiv6209865097ygrp-text p {margin:0 0 1em 0;}#yiv6209865097 #yiv6209865097ygrp-text tt {font-size:120%;}#yiv6209865097 #yiv6209865097ygrp-vital ul li:last-child {border-right:none !important;}#yiv6209865097

Reply to sender . Reply to group . Reply via Web Post . All Messages (18) . Top ^

3a

Re: konversi dari desimal ke format menit atau jam

Thu Dec 17, 2015 12:04 am (PST) . Posted by:

agungraziqi

thank you master

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

4a

Re: Bls: [belajar-excel] konversi dari desimal ke format menit atau

Thu Dec 17, 2015 12:04 am (PST) . Posted by:

agungraziqi

thank you master

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use