Selasa, 26 Januari 2016

[belajar-excel] Digest Number 3734

14 Messages

Digest #3734
1a
Re: Footer Modifikasi by "Mr. Kid" nmkid.family@ymail.com
3b
Re: menghitung jarak terdekat by "Toby kenzo" tobykenzo
4a
5
tanggal expire by "prazt" praztmath
8
Menmpilkn judul header listbox by "Pauzan Ozan" b3ki_cot

Messages

Mon Jan 25, 2016 4:20 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Yang Anda butuhkan ada di sheet bernama marks.
Di VBE, class module Sheet2 (sheet ini, di tab sheet tampak bernama
'marks'), ada sebuah prosedur event. Event yang dimanfaatkan adalah
calculate milik sheet ini.
Isi prosedurnya adalah mengatur sebuah shape yang akan diletakkan di bawah
tabel. Shape berisi teks, gambar atau apapun yang diinginkan.

Pada file tersebut, shape tersebut diatur untuk diletakkan di baris ketiga
setelah record terakhir. Artinya ada 2 baris kosong.
Posisinya diatur untuk rata kanan tabel.
Bagian pengatur ini ada di dalam blok With ... End With.
Silakan diatur dan disesuaikan isi blok With ... End With ini dengan
kebutuhan setempat.

Posisi suatu object (termasuk sebuah shape) adalah dengan menentukan titik
koordinat pojok kiri atasnya.
Jadi, sebuah koordinat titik PKA (pojok kiri atas) akan berisi titik X dan
Y. Titik X diwakili oleh Left dan titik Y diwakili oleh Top.
Itu sebabnya dalam blok with end with tersebut ada proses untuk mengatur
agar nilai titik x alias nilai Left adalah di suatu titik tertentu hasil
perhitungan. Begitu juga titik Y alias nilai Top.

Yang Anda butuhkan adalah menentukan range untuk meletakkan titik pojok
kiri atas si shape, yaitu di baris with blabla, dan nilai Left.
Kalau akan rata kiri tabel, di baris pengatur nilai Left, hapus bagian
pengurangnya.

Wassalam,
Kid

2016-01-25 10:42 GMT+07:00 Fatania Latifa fatania.latifa@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Tolong Mr. Kid saya bingung baca filenya hehe..
>
> 2016-01-22 1:12 GMT+07:00 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>>
>>
>> Hai Latifa,
>>
>> Pakai VBA ya. Seperti yang ada disini
>> <https://app.box.com/s/1yvrnsrwkmehct4wleo1>.
>>
>> Wassalam,
>> Kid
>>
>>
>>
>>
>>
>>
>>
>> 2016-01-21 10:07 GMT+07:00 Fatania Latifa fatania.latifa@gmail.com
>> [belajar-excel] <belajar-excel@yahoogroups.com>:
>>
>>>
>>>
>>> Yang jelas di bawah tabel yang fluktuatif naik turun tergantung datanya,
>>> enaknya bagaimana ya?
>>>
>>> 2016-01-20 16:26 GMT+07:00 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]
>>> <belajar-excel@yahoogroups.com>:
>>>
>>>>
>>>>
>>>> Kalau print 1.5 halaman, tanda tangannya dimana saja ?
>>>> Kalau print 0.5 halaman, tanda tangannya dimana ?
>>>> Kalau print 1.0 halaman, tanda tangannya dimana ?
>>>>
>>>> Regards,
>>>> Kid
>>>>
>>>>
>>>> 2016-01-20 12:38 GMT+07:00 Fatania Latifa fatania.latifa@gmail.com
>>>> [belajar-excel] <belajar-excel@yahoogroups.com>:
>>>>
>>>>>
>>>>>
>>>>> Dear all,
>>>>>
>>>>> Saya ingin tanya, bisa ga sih footer di excel diberikan rumus vlookup?
>>>>> Sebenarnya saya ingin meletakkan tanda tangan di halaman paling bawah,
>>>>> tapi di atasnya data selalu berubah-ubah, jadi biar otomatis baris tanda
>>>>> tangannya di bawah bagaimana? agar tidak tertimpa ketika data banyak, atau
>>>>> terlalu ke bawah kalau data sedikit.
>>>>> Terima kasih.
>>>>>
>>>>>
>>>>
>>>
>>
>
>

Mon Jan 25, 2016 4:37 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Indra,

Fungsi dasar yang digunakan :
1. Date( angka_tahunnya , angka_bulannya , angka_tanggalnya )
2. Left atau Mid untuk mendapatkan angka_tahunnya maupun angka_bulannya
ataupun angka_tanggalnya.

Jika sudah bisa mengambil angka_tahunnya, angka_bulannya, ataupun
angka_tanggalnya dengan fungsi Left atau fungsi Mid, maka akan bisa
menyusun nilai tanggalnya dengan fungsi Date.

Fungsi Left, Mid, dan Date bisa dilihat di Excel Help, karena fungsi-fungsi
ini termasuk fungsi-fungsi dasar Excel yang sebaiknya seluruh pengguna
Excel mempelajarinya saat berkenalan dengan Excel.

Wassalam,
Kid

On Mon, Jan 25, 2016 at 9:59 AM, Indra Sanjaya indradjaja80an@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
> To Mr. Kid
>
> Hasilnya sdh spt yg Sy harapkan. Tp tuk bahan pembelajaran, itu bahasa
> manusianya gmn ya?
> :D:D:D
>
>
> On Monday, January 25, 2016 9:31 AM, Indra Sanjaya <
> indradjaja80an@yahoo.com> wrote:
>
>
> Terima kasih Mr. Kid atas solusinya.
>
> Salam hormat,
> Indra.
>
>
> On Saturday, January 23, 2016 1:54 PM, "'Mr. Kid' mr.nmkid@gmail.com
> [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
>
>
>
> Hai Indra Sanjaya,
>
> File terlampir menggunakan cukup banyak asumsi.
>
> Regards,
> Kid
>
>
>
>
>
> 2016-01-23 12:20 GMT+07:00 Indra Sanjaya indradjaja80an@yahoo.com
> [belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> Dear Para Master Excel,
>
> Saya memiliki data berupa Nama, NIK, No KTP seperti tabel di bawah ini:
>
> *No*
> *Nama*
> *NIK*
> *No KTP*
> 1
> Meggy A
> 0101050370
> 3276041703700001
> 2
> Meggy B
> 0107060566
> 3275030405660020
> 3
> Meggy C
> 0112120272
> 3276051012720003
> 4
> Meggy D
> 1512070181
> 3174081101810005
> 5
> Meggy E
> 0106130769
> 3271030307690011
> 6
> SUSI A
> 0303100190
> 3174094301900001
> 7
> SUSI B
> 2801130993
> 3674036109930010
> 8
> SUSI C
> 2504121287
> 3276106412830002
> 9
> SUSI D
> 0712150792
> 3276045207920004
> 10
> SUSI E
> 0301111089
> 3175096610890005
>
> Bagaimana mengubah 6 digit pertama pada kolom NIK dan digit ke 7 s.d. 12
> pada kolom No KTP agar menjadi format tanggal, bulan, tahun?
>
> Atas solusinya Saya haturkan banyak terima kasih.
>
> Salam,
>
> Indra Sanjaya.
>
>
>
>
>
>
>
>

Mon Jan 25, 2016 6:52 pm (PST) . Posted by:

buraslie

permisi sesepuh sekalian saya mohon pencerahan nya dong
saya dapat tugas magang di telkom untuk menghitung jarak terdekat dari ODP secara looping



berikut ini algoritma saya yg stuck:


Sub Macro2()
Dim x As Long
Dim i As Long
Dim found As Boolean
Range("AL2").Value = x

x = 2
i = 2

Cells(i, 38) = ((Cos(Sin(Cells(i, 30)) * Sin(Cells(x, 47)) + Cos(Cells(i, 30)) * Cos(Cells(x, 47)) * Cos(Cells(x, 48) - Cells(i, 33))) * Cells(i, 34)) * 1000)

found i < 200 = False
x=x+1
Do Until Cells(i, 38) >= 200

found i >= 200 = True

i = i + 1
Exit Do

Loop

End Sub






mohon bantuan nya sesepuh


btw kalo yg ada butuh file nya bisa pm ane suhu


terima kasih


Mon Jan 25, 2016 9:27 pm (PST) . Posted by:

"Toby kenzo" tobykenzo

Disertakan sekalian aja filenya,buat 2 sheet,mana contoh aslinya dan mana yg di harapkan agar teman2 di sini ngga salah presepsi.

Sent from Yahoo Mail on Android

Mon Jan 25, 2016 10:43 pm (PST) . Posted by:

"Rere Sirius" buraslie

http://speedy.sh/Q2QUp/magang-telkom.7z
ini suhu file nya sori kalo lagsung d attachment stuck d tengah jalan

Pada Selasa, 26 Januari 2016 12:27, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
| Disertakan sekalian aja filenya,buat 2 sheet,mana contoh aslinya dan mana yg di harapkan agar teman2 di sini ngga salah presepsi.Sent from Yahoo Mail on Android |

From: buraslie@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] menghitung jarak terdekat
Sent: Tue, Jan 26, 2016 2:27:57 AM


|   permisi sesepuh sekalian saya mohon pencerahan nya dong
 saya dapat tugas magang di telkom untuk menghitung jarak terdekat dari ODP secara looping

berikut ini algoritma saya yg stuck:
Sub Macro2()
Dim x As Long
Dim i As Long
Dim found As Boolean
Range("AL2").Value = x

x = 2
i = 2

 Cells(i, 38) = ((Cos(Sin(Cells(i, 30)) * Sin(Cells(x, 47)) + Cos(Cells(i, 30)) * Cos(Cells(x, 47)) * Cos(Cells(x, 48) - Cells(i, 33))) * Cells(i, 34)) * 1000)

found i < 200 = False
 x=x+1
Do Until Cells(i, 38) >= 200

found i >= 200 = True

i = i + 1
Exit Do

Loop
 
End Sub

mohon bantuan nya sesepuh
btw kalo yg ada butuh file nya bisa pm ane suhu
terima kasih

|

#yiv6290300221 #yiv6290300221 -- #yiv6290300221ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6290300221 #yiv6290300221ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6290300221 #yiv6290300221ygrp-mkp #yiv6290300221hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6290300221 #yiv6290300221ygrp-mkp #yiv6290300221ads {margin-bottom:10px;}#yiv6290300221 #yiv6290300221ygrp-mkp .yiv6290300221ad {padding:0 0;}#yiv6290300221 #yiv6290300221ygrp-mkp .yiv6290300221ad p {margin:0;}#yiv6290300221 #yiv6290300221ygrp-mkp .yiv6290300221ad a {color:#0000ff;text-decoration:none;}#yiv6290300221 #yiv6290300221ygrp-sponsor #yiv6290300221ygrp-lc {font-family:Arial;}#yiv6290300221 #yiv6290300221ygrp-sponsor #yiv6290300221ygrp-lc #yiv6290300221hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6290300221 #yiv6290300221ygrp-sponsor #yiv6290300221ygrp-lc .yiv6290300221ad {margin-bottom:10px;padding:0 0;}#yiv6290300221 #yiv6290300221actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6290300221 #yiv6290300221activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6290300221 #yiv6290300221activity span {font-weight:700;}#yiv6290300221 #yiv6290300221activity span:first-child {text-transform:uppercase;}#yiv6290300221 #yiv6290300221activity span a {color:#5085b6;text-decoration:none;}#yiv6290300221 #yiv6290300221activity span span {color:#ff7900;}#yiv6290300221 #yiv6290300221activity span .yiv6290300221underline {text-decoration:underline;}#yiv6290300221 .yiv6290300221attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6290300221 .yiv6290300221attach div a {text-decoration:none;}#yiv6290300221 .yiv6290300221attach img {border:none;padding-right:5px;}#yiv6290300221 .yiv6290300221attach label {display:block;margin-bottom:5px;}#yiv6290300221 .yiv6290300221attach label a {text-decoration:none;}#yiv6290300221 blockquote {margin:0 0 0 4px;}#yiv6290300221 .yiv6290300221bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6290300221 .yiv6290300221bold a {text-decoration:none;}#yiv6290300221 dd.yiv6290300221last p a {font-family:Verdana;font-weight:700;}#yiv6290300221 dd.yiv6290300221last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6290300221 dd.yiv6290300221last p span.yiv6290300221yshortcuts {margin-right:0;}#yiv6290300221 div.yiv6290300221attach-table div div a {text-decoration:none;}#yiv6290300221 div.yiv6290300221attach-table {width:400px;}#yiv6290300221 div.yiv6290300221file-title a, #yiv6290300221 div.yiv6290300221file-title a:active, #yiv6290300221 div.yiv6290300221file-title a:hover, #yiv6290300221 div.yiv6290300221file-title a:visited {text-decoration:none;}#yiv6290300221 div.yiv6290300221photo-title a, #yiv6290300221 div.yiv6290300221photo-title a:active, #yiv6290300221 div.yiv6290300221photo-title a:hover, #yiv6290300221 div.yiv6290300221photo-title a:visited {text-decoration:none;}#yiv6290300221 div#yiv6290300221ygrp-mlmsg #yiv6290300221ygrp-msg p a span.yiv6290300221yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6290300221 .yiv6290300221green {color:#628c2a;}#yiv6290300221 .yiv6290300221MsoNormal {margin:0 0 0 0;}#yiv6290300221 o {font-size:0;}#yiv6290300221 #yiv6290300221photos div {float:left;width:72px;}#yiv6290300221 #yiv6290300221photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6290300221 #yiv6290300221photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6290300221 #yiv6290300221reco-category {font-size:77%;}#yiv6290300221 #yiv6290300221reco-desc {font-size:77%;}#yiv6290300221 .yiv6290300221replbq {margin:4px;}#yiv6290300221 #yiv6290300221ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6290300221 #yiv6290300221ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6290300221 #yiv6290300221ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6290300221 #yiv6290300221ygrp-mlmsg select, #yiv6290300221 input, #yiv6290300221 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6290300221 #yiv6290300221ygrp-mlmsg pre, #yiv6290300221 code {font:115% monospace;}#yiv6290300221 #yiv6290300221ygrp-mlmsg * {line-height:1.22em;}#yiv6290300221 #yiv6290300221ygrp-mlmsg #yiv6290300221logo {padding-bottom:10px;}#yiv6290300221 #yiv6290300221ygrp-msg p a {font-family:Verdana;}#yiv6290300221 #yiv6290300221ygrp-msg p#yiv6290300221attach-count span {color:#1E66AE;font-weight:700;}#yiv6290300221 #yiv6290300221ygrp-reco #yiv6290300221reco-head {color:#ff7900;font-weight:700;}#yiv6290300221 #yiv6290300221ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6290300221 #yiv6290300221ygrp-sponsor #yiv6290300221ov li a {font-size:130%;text-decoration:none;}#yiv6290300221 #yiv6290300221ygrp-sponsor #yiv6290300221ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6290300221 #yiv6290300221ygrp-sponsor #yiv6290300221ov ul {margin:0;padding:0 0 0 8px;}#yiv6290300221 #yiv6290300221ygrp-text {font-family:Georgia;}#yiv6290300221 #yiv6290300221ygrp-text p {margin:0 0 1em 0;}#yiv6290300221 #yiv6290300221ygrp-text tt {font-size:120%;}#yiv6290300221 #yiv6290300221ygrp-vital ul li:last-child {border-right:none !important;}#yiv6290300221

Tue Jan 26, 2016 12:05 am (PST) . Posted by:

"Toby kenzo" tobykenzo


ya kalo di atas 250kb ngga bakal bisa, mendingan di attch yang jadi pertanyaan anda saja, ngga mesti semuanya...
sorry..filenya ngga bisa saya buka..

Pada Sel, 26/1/16, Rere Sirius buraslie@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] menghitung jarak terdekat
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 26 Januari, 2016, 1:19 PM


 









http://speedy.sh/Q2QUp/magang-telkom.7z
ini suhu
file nya sori kalo lagsung d attachment stuck d tengah
jalan

Pada Selasa, 26
Januari 2016 12:27, "Toby kenzo tobykenzo@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



 













Disertakan sekalian aja
filenya,buat 2 sheet,mana contoh aslinya dan mana yg di
harapkan agar teman2 di sini ngga salah presepsi.
Sent
from Yahoo Mail on Android








From:

buraslie@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>;



To:


<belajar-excel@yahoogroups.com>;



Subject:

[belajar-excel] menghitung jarak
terdekat


Sent:

Tue, Jan 26, 2016 2:27:57 AM






 













permisi sesepuh
sekalian saya mohon pencerahan nya dong
 saya dapat tugas magang di telkom
untuk menghitung jarak terdekat dari ODP secara looping

berikut ini
algoritma saya yg stuck:
Sub Macro2()
Dim x As Long
Dim i As Long
Dim found As Boolean
Range("AL2").Value = x

x = 2
i = 2

 Cells(i, 38) =
((Cos(Sin(Cells(i, 30)) * Sin(Cells(x, 47)) + Cos(Cells(i,
30)) * Cos(Cells(x, 47)) * Cos(Cells(x, 48) - Cells(i, 33)))
* Cells(i, 34)) * 1000)

found i < 200 = False
 x=x+1
Do Until Cells(i, 38)
>= 200

found i
>= 200 = True

i = i +
1
Exit Do

Loop
 
End
Sub


mohon bantuan nya
sesepuh
btw kalo yg ada
butuh file nya bisa pm ane suhu
terima kasih












































#yiv8008208473 #yiv8008208473 --
#yiv8008208473ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv8008208473 #yiv8008208473ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv8008208473 #yiv8008208473ygrp-mkp #yiv8008208473hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv8008208473 #yiv8008208473ygrp-mkp #yiv8008208473ads {
margin-bottom:10px;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad {
padding:0 0;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad p {
margin:0;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad a {
color:#0000ff;text-decoration:none;}
#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc {
font-family:Arial;}

#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc #yiv8008208473hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc .yiv8008208473ad {
margin-bottom:10px;padding:0 0;}

#yiv8008208473 #yiv8008208473actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv8008208473 #yiv8008208473activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv8008208473 #yiv8008208473activity span {
font-weight:700;}

#yiv8008208473 #yiv8008208473activity span:first-child {
text-transform:uppercase;}

#yiv8008208473 #yiv8008208473activity span a {
color:#5085b6;text-decoration:none;}

#yiv8008208473 #yiv8008208473activity span span {
color:#ff7900;}

#yiv8008208473 #yiv8008208473activity span
.yiv8008208473underline {
text-decoration:underline;}

#yiv8008208473 .yiv8008208473attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv8008208473 .yiv8008208473attach div a {
text-decoration:none;}

#yiv8008208473 .yiv8008208473attach img {
border:none;padding-right:5px;}

#yiv8008208473 .yiv8008208473attach label {
display:block;margin-bottom:5px;}

#yiv8008208473 .yiv8008208473attach label a {
text-decoration:none;}

#yiv8008208473 blockquote {
margin:0 0 0 4px;}

#yiv8008208473 .yiv8008208473bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv8008208473 .yiv8008208473bold a {
text-decoration:none;}

#yiv8008208473 dd.yiv8008208473last p a {
font-family:Verdana;font-weight:700;}

#yiv8008208473 dd.yiv8008208473last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv8008208473 dd.yiv8008208473last p
span.yiv8008208473yshortcuts {
margin-right:0;}

#yiv8008208473 div.yiv8008208473attach-table div div a {
text-decoration:none;}

#yiv8008208473 div.yiv8008208473attach-table {
width:400px;}

#yiv8008208473 div.yiv8008208473file-title a, #yiv8008208473
div.yiv8008208473file-title a:active, #yiv8008208473
div.yiv8008208473file-title a:hover, #yiv8008208473
div.yiv8008208473file-title a:visited {
text-decoration:none;}

#yiv8008208473 div.yiv8008208473photo-title a,
#yiv8008208473 div.yiv8008208473photo-title a:active,
#yiv8008208473 div.yiv8008208473photo-title a:hover,
#yiv8008208473 div.yiv8008208473photo-title a:visited {
text-decoration:none;}

#yiv8008208473 div#yiv8008208473ygrp-mlmsg
#yiv8008208473ygrp-msg p a span.yiv8008208473yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv8008208473 .yiv8008208473green {
color:#628c2a;}

#yiv8008208473 .yiv8008208473MsoNormal {
margin:0 0 0 0;}

#yiv8008208473 o {
font-size:0;}

#yiv8008208473 #yiv8008208473photos div {
float:left;width:72px;}

#yiv8008208473 #yiv8008208473photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv8008208473 #yiv8008208473photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv8008208473 #yiv8008208473reco-category {
font-size:77%;}

#yiv8008208473 #yiv8008208473reco-desc {
font-size:77%;}

#yiv8008208473 .yiv8008208473replbq {
margin:4px;}

#yiv8008208473 #yiv8008208473ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg select,
#yiv8008208473 input, #yiv8008208473 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg pre, #yiv8008208473
code {
font:115% monospace;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg * {
line-height:1.22em;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg #yiv8008208473logo {
padding-bottom:10px;}


#yiv8008208473 #yiv8008208473ygrp-msg p a {
font-family:Verdana;}

#yiv8008208473 #yiv8008208473ygrp-msg
p#yiv8008208473attach-count span {
color:#1E66AE;font-weight:700;}

#yiv8008208473 #yiv8008208473ygrp-reco
#yiv8008208473reco-head {
color:#ff7900;font-weight:700;}

#yiv8008208473 #yiv8008208473ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
li a {
font-size:130%;text-decoration:none;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv8008208473 #yiv8008208473ygrp-text {
font-family:Georgia;}

#yiv8008208473 #yiv8008208473ygrp-text p {
margin:0 0 1em 0;}

#yiv8008208473 #yiv8008208473ygrp-text tt {
font-size:120%;}

#yiv8008208473 #yiv8008208473ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv8008208473

Tue Jan 26, 2016 12:48 am (PST) . Posted by:

"Rere Sirius" buraslie

ini suhu

Pada Selasa, 26 Januari 2016 15:05, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
ya kalo di atas 250kb ngga bakal bisa, mendingan di attch yang jadi pertanyaan anda saja, ngga mesti semuanya...
sorry..filenya ngga bisa saya buka..

Pada Sel, 26/1/16, Rere Sirius buraslie@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] menghitung jarak terdekat
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 26 Januari, 2016, 1:19 PM


 









http://speedy.sh/Q2QUp/magang-telkom.7z
ini suhu
file nya sori kalo lagsung d attachment stuck d tengah
jalan

Pada Selasa, 26
Januari 2016 12:27, "Toby kenzo tobykenzo@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



 













Disertakan sekalian aja
filenya,buat 2 sheet,mana contoh aslinya dan mana yg di
harapkan agar teman2 di sini ngga salah presepsi.
Sent
from Yahoo Mail on Android







From:

buraslie@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>;



To:


<belajar-excel@yahoogroups.com>;



Subject:

[belajar-excel] menghitung jarak
terdekat


Sent:

Tue, Jan 26, 2016 2:27:57 AM






 













permisi sesepuh
sekalian saya mohon pencerahan nya dong
 saya dapat tugas magang di telkom
untuk menghitung jarak terdekat dari ODP secara looping

berikut ini
algoritma saya yg stuck:
Sub Macro2()
Dim x As Long
Dim i As Long
Dim found As Boolean
Range("AL2").Value = x

x = 2
i = 2

 Cells(i, 38) =
((Cos(Sin(Cells(i, 30)) * Sin(Cells(x, 47)) + Cos(Cells(i,
30)) * Cos(Cells(x, 47)) * Cos(Cells(x, 48) - Cells(i, 33)))
* Cells(i, 34)) * 1000)

found i < 200 = False
 x=x+1
Do Until Cells(i, 38)
>= 200

found i
>= 200 = True

i = i +
1
Exit Do

Loop
 
End
Sub


mohon bantuan nya
sesepuh
btw kalo yg ada

butuh file nya bisa pm ane suhu
terima kasih















#yiv8008208473 #yiv8008208473 --
#yiv8008208473ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv8008208473 #yiv8008208473ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv8008208473 #yiv8008208473ygrp-mkp #yiv8008208473hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv8008208473 #yiv8008208473ygrp-mkp #yiv8008208473ads {
margin-bottom:10px;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad {
padding:0 0;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad p {
margin:0;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad a {
color:#0000ff;text-decoration:none;}
#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc {
font-family:Arial;}

#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc #yiv8008208473hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc .yiv8008208473ad {
margin-bottom:10px;padding:0 0;}

#yiv8008208473 #yiv8008208473actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv8008208473 #yiv8008208473activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv8008208473 #yiv8008208473activity span {
font-weight:700;}

#yiv8008208473 #yiv8008208473activity span:first-child {
text-transform:uppercase;}

#yiv8008208473 #yiv8008208473activity span a {
color:#5085b6;text-decoration:none;}


#yiv8008208473 #yiv8008208473activity span span {
color:#ff7900;}

#yiv8008208473 #yiv8008208473activity span
.yiv8008208473underline {
text-decoration:underline;}

#yiv8008208473 .yiv8008208473attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv8008208473 .yiv8008208473attach div a {
text-decoration:none;}

#yiv8008208473 .yiv8008208473attach img {
border:none;padding-right:5px;}

#yiv8008208473 .yiv8008208473attach label {
display:block;margin-bottom:5px;}

#yiv8008208473 .yiv8008208473attach label a {
text-decoration:none;}

#yiv8008208473 blockquote {
margin:0 0 0 4px;}

#yiv8008208473 .yiv8008208473bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv8008208473 .yiv8008208473bold a {
text-decoration:none;}

#yiv8008208473 dd.yiv8008208473last p a {
font-family:Verdana;font-weight:700;}

#yiv8008208473 dd.yiv8008208473last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv8008208473 dd.yiv8008208473last p
span.yiv8008208473yshortcuts {
margin-right:0;}

#yiv8008208473 div.yiv8008208473attach-table div div a {
text-decoration:none;}

#yiv8008208473 div.yiv8008208473attach-table {
width:400px;}

#yiv8008208473 div.yiv8008208473file-title a, #yiv8008208473
div.yiv8008208473file-title a:active, #yiv8008208473
div.yiv8008208473file-title a:hover, #yiv8008208473
div.yiv8008208473file-title a:visited {
text-decoration:none;}

#yiv8008208473 div.yiv8008208473photo-title a,
#yiv8008208473 div.yiv8008208473photo-title a:active,
#yiv8008208473 div.yiv8008208473photo-title a:hover,
#yiv8008208473 div.yiv8008208473photo-title a:visited {
text-decoration:none;}

#yiv8008208473 div#yiv8008208473ygrp-mlmsg
#yiv8008208473ygrp-msg p a span.yiv8008208473yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv8008208473 .yiv8008208473green {
color:#628c2a;}

#yiv8008208473 .yiv8008208473MsoNormal {
margin:0 0 0 0;}

#yiv8008208473 o {
font-size:0;}

#yiv8008208473 #yiv8008208473photos div {
float:left;width:72px;}

#yiv8008208473 #yiv8008208473photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv8008208473 #yiv8008208473photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv8008208473 #yiv8008208473reco-category {
font-size:77%;}

#yiv8008208473 #yiv8008208473reco-desc {
font-size:77%;}

#yiv8008208473 .yiv8008208473replbq {
margin:4px;}

#yiv8008208473 #yiv8008208473ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg select,
#yiv8008208473 input, #yiv8008208473 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg pre, #yiv8008208473
code {
font:115% monospace;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg * {
line-height:1.22em;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg #yiv8008208473logo {
padding-bottom:10px;}


#yiv8008208473 #yiv8008208473ygrp-msg p a {
font-family:Verdana;}

#yiv8008208473 #yiv8008208473ygrp-msg
p#yiv8008208473attach-count span {
color:#1E66AE;font-weight:700;}

#yiv8008208473 #yiv8008208473ygrp-reco
#yiv8008208473reco-head {
color:#ff7900;font-weight:700;}

#yiv8008208473 #yiv8008208473ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
li a {

font-size:130%;text-decoration:none;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv8008208473 #yiv8008208473ygrp-text {
font-family:Georgia;}

#yiv8008208473 #yiv8008208473ygrp-text p {
margin:0 0 1em 0;}

#yiv8008208473 #yiv8008208473ygrp-text tt {
font-size:120%;}

#yiv8008208473 #yiv8008208473ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv8008208473
#yiv7661455406 #yiv7661455406 -- #yiv7661455406ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7661455406 #yiv7661455406ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7661455406 #yiv7661455406ygrp-mkp #yiv7661455406hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7661455406 #yiv7661455406ygrp-mkp #yiv7661455406ads {margin-bottom:10px;}#yiv7661455406 #yiv7661455406ygrp-mkp .yiv7661455406ad {padding:0 0;}#yiv7661455406 #yiv7661455406ygrp-mkp .yiv7661455406ad p {margin:0;}#yiv7661455406 #yiv7661455406ygrp-mkp .yiv7661455406ad a {color:#0000ff;text-decoration:none;}#yiv7661455406 #yiv7661455406ygrp-sponsor #yiv7661455406ygrp-lc {font-family:Arial;}#yiv7661455406 #yiv7661455406ygrp-sponsor #yiv7661455406ygrp-lc #yiv7661455406hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7661455406 #yiv7661455406ygrp-sponsor #yiv7661455406ygrp-lc .yiv7661455406ad {margin-bottom:10px;padding:0 0;}#yiv7661455406 #yiv7661455406actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7661455406 #yiv7661455406activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7661455406 #yiv7661455406activity span {font-weight:700;}#yiv7661455406 #yiv7661455406activity span:first-child {text-transform:uppercase;}#yiv7661455406 #yiv7661455406activity span a {color:#5085b6;text-decoration:none;}#yiv7661455406 #yiv7661455406activity span span {color:#ff7900;}#yiv7661455406 #yiv7661455406activity span .yiv7661455406underline {text-decoration:underline;}#yiv7661455406 .yiv7661455406attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7661455406 .yiv7661455406attach div a {text-decoration:none;}#yiv7661455406 .yiv7661455406attach img {border:none;padding-right:5px;}#yiv7661455406 .yiv7661455406attach label {display:block;margin-bottom:5px;}#yiv7661455406 .yiv7661455406attach label a {text-decoration:none;}#yiv7661455406 blockquote {margin:0 0 0 4px;}#yiv7661455406 .yiv7661455406bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7661455406 .yiv7661455406bold a {text-decoration:none;}#yiv7661455406 dd.yiv7661455406last p a {font-family:Verdana;font-weight:700;}#yiv7661455406 dd.yiv7661455406last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7661455406 dd.yiv7661455406last p span.yiv7661455406yshortcuts {margin-right:0;}#yiv7661455406 div.yiv7661455406attach-table div div a {text-decoration:none;}#yiv7661455406 div.yiv7661455406attach-table {width:400px;}#yiv7661455406 div.yiv7661455406file-title a, #yiv7661455406 div.yiv7661455406file-title a:active, #yiv7661455406 div.yiv7661455406file-title a:hover, #yiv7661455406 div.yiv7661455406file-title a:visited {text-decoration:none;}#yiv7661455406 div.yiv7661455406photo-title a, #yiv7661455406 div.yiv7661455406photo-title a:active, #yiv7661455406 div.yiv7661455406photo-title a:hover, #yiv7661455406 div.yiv7661455406photo-title a:visited {text-decoration:none;}#yiv7661455406 div#yiv7661455406ygrp-mlmsg #yiv7661455406ygrp-msg p a span.yiv7661455406yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7661455406 .yiv7661455406green {color:#628c2a;}#yiv7661455406 .yiv7661455406MsoNormal {margin:0 0 0 0;}#yiv7661455406 o {font-size:0;}#yiv7661455406 #yiv7661455406photos div {float:left;width:72px;}#yiv7661455406 #yiv7661455406photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7661455406 #yiv7661455406photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7661455406 #yiv7661455406reco-category {font-size:77%;}#yiv7661455406 #yiv7661455406reco-desc {font-size:77%;}#yiv7661455406 .yiv7661455406replbq {margin:4px;}#yiv7661455406 #yiv7661455406ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7661455406 #yiv7661455406ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7661455406 #yiv7661455406ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7661455406 #yiv7661455406ygrp-mlmsg select, #yiv7661455406 input, #yiv7661455406 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7661455406 #yiv7661455406ygrp-mlmsg pre, #yiv7661455406 code {font:115% monospace;}#yiv7661455406 #yiv7661455406ygrp-mlmsg * {line-height:1.22em;}#yiv7661455406 #yiv7661455406ygrp-mlmsg #yiv7661455406logo {padding-bottom:10px;}#yiv7661455406 #yiv7661455406ygrp-msg p a {font-family:Verdana;}#yiv7661455406 #yiv7661455406ygrp-msg p#yiv7661455406attach-count span {color:#1E66AE;font-weight:700;}#yiv7661455406 #yiv7661455406ygrp-reco #yiv7661455406reco-head {color:#ff7900;font-weight:700;}#yiv7661455406 #yiv7661455406ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7661455406 #yiv7661455406ygrp-sponsor #yiv7661455406ov li a {font-size:130%;text-decoration:none;}#yiv7661455406 #yiv7661455406ygrp-sponsor #yiv7661455406ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7661455406 #yiv7661455406ygrp-sponsor #yiv7661455406ov ul {margin:0;padding:0 0 0 8px;}#yiv7661455406 #yiv7661455406ygrp-text {font-family:Georgia;}#yiv7661455406 #yiv7661455406ygrp-text p {margin:0 0 1em 0;}#yiv7661455406 #yiv7661455406ygrp-text tt {font-size:120%;}#yiv7661455406 #yiv7661455406ygrp-vital ul li:last-child {border-right:none !important;}#yiv7661455406

Tue Jan 26, 2016 12:48 am (PST) . Posted by:

"Rere Sirius" buraslie

yg uda di isi pingin nya kaya gituyang d block itu blm bisa running program nya

Pada Selasa, 26 Januari 2016 15:36, Rere Sirius <buraslie@yahoo.com> menulis:


ini suhu

Pada Selasa, 26 Januari 2016 15:05, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
ya kalo di atas 250kb ngga bakal bisa, mendingan di attch yang jadi pertanyaan anda saja, ngga mesti semuanya...
sorry..filenya ngga bisa saya buka..

Pada Sel, 26/1/16, Rere Sirius buraslie@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] menghitung jarak terdekat
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 26 Januari, 2016, 1:19 PM


 










http://speedy.sh/Q2QUp/magang-telkom.7z
ini suhu
file nya sori kalo lagsung d attachment stuck d tengah
jalan

Pada Selasa, 26
Januari 2016 12:27, "Toby kenzo tobykenzo@yahoo.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



 













Disertakan sekalian aja
filenya,buat 2 sheet,mana contoh aslinya dan mana yg di
harapkan agar teman2 di sini ngga salah presepsi.
Sent
from Yahoo Mail on Android








From:

buraslie@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>;



To:


<belajar-excel@yahoogroups.com>;



Subject:

[belajar-excel] menghitung jarak
terdekat


Sent:

Tue, Jan 26, 2016 2:27:57 AM






 













permisi sesepuh
sekalian saya mohon pencerahan nya dong
 saya dapat tugas magang di telkom
untuk menghitung jarak terdekat dari ODP secara looping

berikut ini
algoritma saya yg stuck:
Sub Macro2()
Dim x As Long
Dim i As Long
Dim found As Boolean
Range("AL2").Value = x

x = 2
i = 2

 Cells(i, 38) =
((Cos(Sin(Cells(i, 30)) * Sin(Cells(x, 47)) + Cos(Cells(i,
30)) * Cos(Cells(x, 47)) * Cos(Cells(x, 48) - Cells(i, 33)))
* Cells(i, 34)) * 1000)

found i < 200 = False
 x=x+1
Do Until Cells(i, 38)
>= 200

found i
>= 200 = True

i = i +
1
Exit Do

Loop
 
End
Sub


mohon bantuan nya
sesepuh
btw kalo yg ada
butuh file nya bisa pm ane suhu
terima kasih











































#yiv8008208473 #yiv8008208473 --
#yiv8008208473ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv8008208473 #yiv8008208473ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv8008208473 #yiv8008208473ygrp-mkp #yiv8008208473hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv8008208473 #yiv8008208473ygrp-mkp #yiv8008208473ads {
margin-bottom:10px;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad {
padding:0 0;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad p {
margin:0;}

#yiv8008208473 #yiv8008208473ygrp-mkp .yiv8008208473ad a {
color:#0000ff;text-decoration:none;}
#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc {
font-family:Arial;}

#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc #yiv8008208473hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv8008208473 #yiv8008208473ygrp-sponsor
#yiv8008208473ygrp-lc .yiv8008208473ad {
margin-bottom:10px;padding:0 0;}

#yiv8008208473 #yiv8008208473actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv8008208473 #yiv8008208473activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv8008208473 #yiv8008208473activity span {
font-weight:700;}

#yiv8008208473 #yiv8008208473activity span:first-child {
text-transform:uppercase;}

#yiv8008208473 #yiv8008208473activity span a {
color:#5085b6;text-decoration:none;}

#yiv8008208473 #yiv8008208473activity span span {
color:#ff7900;}

#yiv8008208473 #yiv8008208473activity span
.yiv8008208473underline {
text-decoration:underline;}

#yiv8008208473 .yiv8008208473attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv8008208473 .yiv8008208473attach div a {
text-decoration:none;}

#yiv8008208473 .yiv8008208473attach img {
border:none;padding-right:5px;}

#yiv8008208473 .yiv8008208473attach label {
display:block;margin-bottom:5px;}

#yiv8008208473 .yiv8008208473attach label a {
text-decoration:none;}

#yiv8008208473 blockquote {
margin:0 0 0 4px;}

#yiv8008208473 .yiv8008208473bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv8008208473 .yiv8008208473bold a {
text-decoration:none;}

#yiv8008208473 dd.yiv8008208473last p a {
font-family:Verdana;font-weight:700;}

#yiv8008208473 dd.yiv8008208473last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv8008208473 dd.yiv8008208473last p
span.yiv8008208473yshortcuts {
margin-right:0;}

#yiv8008208473 div.yiv8008208473attach-table div div a {
text-decoration:none;}

#yiv8008208473 div.yiv8008208473attach-table {
width:400px;}

#yiv8008208473 div.yiv8008208473file-title a, #yiv8008208473
div.yiv8008208473file-title a:active, #yiv8008208473
div.yiv8008208473file-title a:hover, #yiv8008208473
div.yiv8008208473file-title a:visited {
text-decoration:none;}

#yiv8008208473 div.yiv8008208473photo-title a,
#yiv8008208473 div.yiv8008208473photo-title a:active,
#yiv8008208473 div.yiv8008208473photo-title a:hover,
#yiv8008208473 div.yiv8008208473photo-title a:visited {
text-decoration:none;}

#yiv8008208473 div#yiv8008208473ygrp-mlmsg
#yiv8008208473ygrp-msg p a span.yiv8008208473yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv8008208473 .yiv8008208473green {
color:#628c2a;}

#yiv8008208473 .yiv8008208473MsoNormal {
margin:0 0 0 0;}

#yiv8008208473 o {
font-size:0;}

#yiv8008208473 #yiv8008208473photos div {
float:left;width:72px;}

#yiv8008208473 #yiv8008208473photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv8008208473 #yiv8008208473photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv8008208473 #yiv8008208473reco-category {
font-size:77%;}

#yiv8008208473 #yiv8008208473reco-desc {
font-size:77%;}

#yiv8008208473 .yiv8008208473replbq {
margin:4px;}

#yiv8008208473 #yiv8008208473ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg select,
#yiv8008208473 input, #yiv8008208473 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg pre, #yiv8008208473

code {
font:115% monospace;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg * {
line-height:1.22em;}

#yiv8008208473 #yiv8008208473ygrp-mlmsg #yiv8008208473logo {
padding-bottom:10px;}


#yiv8008208473 #yiv8008208473ygrp-msg p a {
font-family:Verdana;}

#yiv8008208473 #yiv8008208473ygrp-msg

p#yiv8008208473attach-count span {
color:#1E66AE;font-weight:700;}

#yiv8008208473 #yiv8008208473ygrp-reco
#yiv8008208473reco-head {
color:#ff7900;font-weight:700;}

#yiv8008208473 #yiv8008208473ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
li a {
font-size:130%;text-decoration:none;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv8008208473 #yiv8008208473ygrp-sponsor #yiv8008208473ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv8008208473 #yiv8008208473ygrp-text {
font-family:Georgia;}

#yiv8008208473 #yiv8008208473ygrp-text p {
margin:0 0 1em 0;}

#yiv8008208473 #yiv8008208473ygrp-text tt {
font-size:120%;}

#yiv8008208473 #yiv8008208473ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv8008208473
#yiv2605282400 -- #yiv2605282400ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2605282400 #yiv2605282400ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2605282400 #yiv2605282400ygrp-mkp #yiv2605282400hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2605282400 #yiv2605282400ygrp-mkp #yiv2605282400ads {margin-bottom:10px;}#yiv2605282400 #yiv2605282400ygrp-mkp .yiv2605282400ad {padding:0 0;}#yiv2605282400 #yiv2605282400ygrp-mkp .yiv2605282400ad p {margin:0;}#yiv2605282400 #yiv2605282400ygrp-mkp .yiv2605282400ad a {color:#0000ff;text-decoration:none;}#yiv2605282400 #yiv2605282400ygrp-sponsor #yiv2605282400ygrp-lc {font-family:Arial;}#yiv2605282400 #yiv2605282400ygrp-sponsor #yiv2605282400ygrp-lc #yiv2605282400hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2605282400 #yiv2605282400ygrp-sponsor #yiv2605282400ygrp-lc .yiv2605282400ad {margin-bottom:10px;padding:0 0;}#yiv2605282400 #yiv2605282400actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2605282400 #yiv2605282400activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2605282400 #yiv2605282400activity span {font-weight:700;}#yiv2605282400 #yiv2605282400activity span:first-child {text-transform:uppercase;}#yiv2605282400 #yiv2605282400activity span a {color:#5085b6;text-decoration:none;}#yiv2605282400 #yiv2605282400activity span span {color:#ff7900;}#yiv2605282400 #yiv2605282400activity span .yiv2605282400underline {text-decoration:underline;}#yiv2605282400 .yiv2605282400attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2605282400 .yiv2605282400attach div a {text-decoration:none;}#yiv2605282400 .yiv2605282400attach img {border:none;padding-right:5px;}#yiv2605282400 .yiv2605282400attach label {display:block;margin-bottom:5px;}#yiv2605282400 .yiv2605282400attach label a {text-decoration:none;}#yiv2605282400 blockquote {margin:0 0 0 4px;}#yiv2605282400 .yiv2605282400bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2605282400 .yiv2605282400bold a {text-decoration:none;}#yiv2605282400 dd.yiv2605282400last p a {font-family:Verdana;font-weight:700;}#yiv2605282400 dd.yiv2605282400last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2605282400 dd.yiv2605282400last p span.yiv2605282400yshortcuts {margin-right:0;}#yiv2605282400 div.yiv2605282400attach-table div div a {text-decoration:none;}#yiv2605282400 div.yiv2605282400attach-table {width:400px;}#yiv2605282400 div.yiv2605282400file-title a, #yiv2605282400 div.yiv2605282400file-title a:active, #yiv2605282400 div.yiv2605282400file-title a:hover, #yiv2605282400 div.yiv2605282400file-title a:visited {text-decoration:none;}#yiv2605282400 div.yiv2605282400photo-title a, #yiv2605282400 div.yiv2605282400photo-title a:active, #yiv2605282400 div.yiv2605282400photo-title a:hover, #yiv2605282400 div.yiv2605282400photo-title a:visited {text-decoration:none;}#yiv2605282400 div#yiv2605282400ygrp-mlmsg #yiv2605282400ygrp-msg p a span.yiv2605282400yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2605282400 .yiv2605282400green {color:#628c2a;}#yiv2605282400 .yiv2605282400MsoNormal {margin:0 0 0 0;}#yiv2605282400 o {font-size:0;}#yiv2605282400 #yiv2605282400photos div {float:left;width:72px;}#yiv2605282400 #yiv2605282400photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2605282400 #yiv2605282400photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2605282400 #yiv2605282400reco-category {font-size:77%;}#yiv2605282400 #yiv2605282400reco-desc {font-size:77%;}#yiv2605282400 .yiv2605282400replbq {margin:4px;}#yiv2605282400 #yiv2605282400ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2605282400 #yiv2605282400ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2605282400 #yiv2605282400ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2605282400 #yiv2605282400ygrp-mlmsg select, #yiv2605282400 input, #yiv2605282400 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2605282400 #yiv2605282400ygrp-mlmsg pre, #yiv2605282400 code {font:115% monospace;}#yiv2605282400 #yiv2605282400ygrp-mlmsg * {line-height:1.22em;}#yiv2605282400 #yiv2605282400ygrp-mlmsg #yiv2605282400logo {padding-bottom:10px;}#yiv2605282400 #yiv2605282400ygrp-msg p a {font-family:Verdana;}#yiv2605282400 #yiv2605282400ygrp-msg p#yiv2605282400attach-count span {color:#1E66AE;font-weight:700;}#yiv2605282400 #yiv2605282400ygrp-reco #yiv2605282400reco-head {color:#ff7900;font-weight:700;}#yiv2605282400 #yiv2605282400ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2605282400 #yiv2605282400ygrp-sponsor #yiv2605282400ov li a {font-size:130%;text-decoration:none;}#yiv2605282400 #yiv2605282400ygrp-sponsor #yiv2605282400ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2605282400 #yiv2605282400ygrp-sponsor #yiv2605282400ov ul {margin:0;padding:0 0 0 8px;}#yiv2605282400 #yiv2605282400ygrp-text {font-family:Georgia;}#yiv2605282400 #yiv2605282400ygrp-text p {margin:0 0 1em 0;}#yiv2605282400 #yiv2605282400ygrp-text tt {font-size:120%;}#yiv2605282400 #yiv2605282400ygrp-vital ul li:last-child {border-right:none !important;}#yiv2605282400

Mon Jan 25, 2016 7:01 pm (PST) . Posted by:

"ris ha" har1sn.excel

Assalamu'alaikum...
Mohon bantuannya para master semua. Saya mau mengaktifkan sheets tapi merujuk pada cell.bentuk macronya seperti ini
Sheets("90").Activate
Nah, angka 90 itu berada pada Sheets("Setting").Range("R2")Saya mencoba
Sheets(Sheets("Setting&quot;).Range("R2").Value).Activate namun muncul error "Script Out of Range"
Bagaimana ya macronya untuk memecahkan masalah tersebut
SalamHaris

Mon Jan 25, 2016 7:51 pm (PST) . Posted by:

"ris ha" har1sn.excel

Alhamdulillah udah nemu
Sheets(Format(Sheets("Setting").Range("R2").Value)).Select

On Tuesday, January 26, 2016 9:59 AM, "ris ha har1sn.excel@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Assalamu'alaikum...
Mohon bantuannya para master semua. Saya mau mengaktifkan sheets tapi merujuk pada cell.bentuk macronya seperti ini
Sheets("90").Activate
Nah, angka 90 itu berada pada Sheets("Setting").Range("R2")Saya mencoba
Sheets(Sheets("Setting&quot;).Range("R2").Value).Activate namun muncul error "Script Out of Range"
Bagaimana ya macronya untuk memecahkan masalah tersebut
SalamHaris
#yiv9142480917 #yiv9142480917 -- #yiv9142480917ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9142480917 #yiv9142480917ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9142480917 #yiv9142480917ygrp-mkp #yiv9142480917hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9142480917 #yiv9142480917ygrp-mkp #yiv9142480917ads {margin-bottom:10px;}#yiv9142480917 #yiv9142480917ygrp-mkp .yiv9142480917ad {padding:0 0;}#yiv9142480917 #yiv9142480917ygrp-mkp .yiv9142480917ad p {margin:0;}#yiv9142480917 #yiv9142480917ygrp-mkp .yiv9142480917ad a {color:#0000ff;text-decoration:none;}#yiv9142480917 #yiv9142480917ygrp-sponsor #yiv9142480917ygrp-lc {font-family:Arial;}#yiv9142480917 #yiv9142480917ygrp-sponsor #yiv9142480917ygrp-lc #yiv9142480917hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9142480917 #yiv9142480917ygrp-sponsor #yiv9142480917ygrp-lc .yiv9142480917ad {margin-bottom:10px;padding:0 0;}#yiv9142480917 #yiv9142480917actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9142480917 #yiv9142480917activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9142480917 #yiv9142480917activity span {font-weight:700;}#yiv9142480917 #yiv9142480917activity span:first-child {text-transform:uppercase;}#yiv9142480917 #yiv9142480917activity span a {color:#5085b6;text-decoration:none;}#yiv9142480917 #yiv9142480917activity span span {color:#ff7900;}#yiv9142480917 #yiv9142480917activity span .yiv9142480917underline {text-decoration:underline;}#yiv9142480917 .yiv9142480917attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9142480917 .yiv9142480917attach div a {text-decoration:none;}#yiv9142480917 .yiv9142480917attach img {border:none;padding-right:5px;}#yiv9142480917 .yiv9142480917attach label {display:block;margin-bottom:5px;}#yiv9142480917 .yiv9142480917attach label a {text-decoration:none;}#yiv9142480917 blockquote {margin:0 0 0 4px;}#yiv9142480917 .yiv9142480917bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9142480917 .yiv9142480917bold a {text-decoration:none;}#yiv9142480917 dd.yiv9142480917last p a {font-family:Verdana;font-weight:700;}#yiv9142480917 dd.yiv9142480917last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9142480917 dd.yiv9142480917last p span.yiv9142480917yshortcuts {margin-right:0;}#yiv9142480917 div.yiv9142480917attach-table div div a {text-decoration:none;}#yiv9142480917 div.yiv9142480917attach-table {width:400px;}#yiv9142480917 div.yiv9142480917file-title a, #yiv9142480917 div.yiv9142480917file-title a:active, #yiv9142480917 div.yiv9142480917file-title a:hover, #yiv9142480917 div.yiv9142480917file-title a:visited {text-decoration:none;}#yiv9142480917 div.yiv9142480917photo-title a, #yiv9142480917 div.yiv9142480917photo-title a:active, #yiv9142480917 div.yiv9142480917photo-title a:hover, #yiv9142480917 div.yiv9142480917photo-title a:visited {text-decoration:none;}#yiv9142480917 div#yiv9142480917ygrp-mlmsg #yiv9142480917ygrp-msg p a span.yiv9142480917yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9142480917 .yiv9142480917green {color:#628c2a;}#yiv9142480917 .yiv9142480917MsoNormal {margin:0 0 0 0;}#yiv9142480917 o {font-size:0;}#yiv9142480917 #yiv9142480917photos div {float:left;width:72px;}#yiv9142480917 #yiv9142480917photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9142480917 #yiv9142480917photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9142480917 #yiv9142480917reco-category {font-size:77%;}#yiv9142480917 #yiv9142480917reco-desc {font-size:77%;}#yiv9142480917 .yiv9142480917replbq {margin:4px;}#yiv9142480917 #yiv9142480917ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9142480917 #yiv9142480917ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9142480917 #yiv9142480917ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9142480917 #yiv9142480917ygrp-mlmsg select, #yiv9142480917 input, #yiv9142480917 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9142480917 #yiv9142480917ygrp-mlmsg pre, #yiv9142480917 code {font:115% monospace;}#yiv9142480917 #yiv9142480917ygrp-mlmsg * {line-height:1.22em;}#yiv9142480917 #yiv9142480917ygrp-mlmsg #yiv9142480917logo {padding-bottom:10px;}#yiv9142480917 #yiv9142480917ygrp-msg p a {font-family:Verdana;}#yiv9142480917 #yiv9142480917ygrp-msg p#yiv9142480917attach-count span {color:#1E66AE;font-weight:700;}#yiv9142480917 #yiv9142480917ygrp-reco #yiv9142480917reco-head {color:#ff7900;font-weight:700;}#yiv9142480917 #yiv9142480917ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9142480917 #yiv9142480917ygrp-sponsor #yiv9142480917ov li a {font-size:130%;text-decoration:none;}#yiv9142480917 #yiv9142480917ygrp-sponsor #yiv9142480917ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9142480917 #yiv9142480917ygrp-sponsor #yiv9142480917ov ul {margin:0;padding:0 0 0 8px;}#yiv9142480917 #yiv9142480917ygrp-text {font-family:Georgia;}#yiv9142480917 #yiv9142480917ygrp-text p {margin:0 0 1em 0;}#yiv9142480917 #yiv9142480917ygrp-text tt {font-size:120%;}#yiv9142480917 #yiv9142480917ygrp-vital ul li:last-child {border-right:none !important;}#yiv9142480917

Mon Jan 25, 2016 10:11 pm (PST) . Posted by:

"prazt" praztmath

Dear para master..
Mohon bantuannya saya membuat file excel yg rencana akan expired pd tahun
2018, dan saya buka di excel 2007 tgl expired trsebut berjalan sesuai yg di
inginkan,tapi saat dibuka di excel 2010 muncul pesan error "can't find
project or library" seperti pada lampiran...kira kira masalahnya apa dan
bagaimana penyelesaiannya ? Mohon bantuannya...

---
Email tidak mengandung virus pemeriksaan mengunakan piranti Avast antivirus.
https://www.avast.com/antivirus

Tue Jan 26, 2016 12:02 am (PST) . Posted by:

"Toby kenzo" tobykenzo


Dear Prazt,

Kemungkinan pada tool library di Excel 2010 untuk tool "Tanggal" belum anda register.
Sekarang untuk menepatkan tanggal anda menggunakan "DtPicker atau Month view..

TerimaKasih.

Pada Sel, 26/1/16, 'prazt' praztmath@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: [belajar-excel] tanggal expire [1 Attachment]
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 26 Januari, 2016, 1:11 PM


 









Dear para master..
Mohon bantuannya saya membuat file excel yg
rencana akan expired pd tahun 2018, dan saya buka di excel
2007 tgl expired trsebut berjalan sesuai yg di inginkan,tapi
saat dibuka di excel 2010 muncul pesan error "can't
find project or library" seperti pada lampiran...kira
kira masalahnya apa dan bagaimana penyelesaiannya ? Mohon
bantuannya...










Email tidak mengandung virus pemeriksaan mengunakan
piranti Avast antivirus.

www.avast.com














#yiv7146606929 #yiv7146606929 --
#yiv7146606929ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv7146606929 #yiv7146606929ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv7146606929 #yiv7146606929ygrp-mkp #yiv7146606929hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv7146606929 #yiv7146606929ygrp-mkp #yiv7146606929ads {
margin-bottom:10px;}

#yiv7146606929 #yiv7146606929ygrp-mkp .yiv7146606929ad {
padding:0 0;}

#yiv7146606929 #yiv7146606929ygrp-mkp .yiv7146606929ad p {
margin:0;}

#yiv7146606929 #yiv7146606929ygrp-mkp .yiv7146606929ad a {
color:#0000ff;text-decoration:none;}
#yiv7146606929 #yiv7146606929ygrp-sponsor
#yiv7146606929ygrp-lc {
font-family:Arial;}

#yiv7146606929 #yiv7146606929ygrp-sponsor
#yiv7146606929ygrp-lc #yiv7146606929hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv7146606929 #yiv7146606929ygrp-sponsor
#yiv7146606929ygrp-lc .yiv7146606929ad {
margin-bottom:10px;padding:0 0;}

#yiv7146606929 #yiv7146606929actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv7146606929 #yiv7146606929activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv7146606929 #yiv7146606929activity span {
font-weight:700;}

#yiv7146606929 #yiv7146606929activity span:first-child {
text-transform:uppercase;}

#yiv7146606929 #yiv7146606929activity span a {
color:#5085b6;text-decoration:none;}

#yiv7146606929 #yiv7146606929activity span span {
color:#ff7900;}

#yiv7146606929 #yiv7146606929activity span
.yiv7146606929underline {
text-decoration:underline;}

#yiv7146606929 .yiv7146606929attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv7146606929 .yiv7146606929attach div a {
text-decoration:none;}

#yiv7146606929 .yiv7146606929attach img {
border:none;padding-right:5px;}

#yiv7146606929 .yiv7146606929attach label {
display:block;margin-bottom:5px;}

#yiv7146606929 .yiv7146606929attach label a {
text-decoration:none;}

#yiv7146606929 blockquote {
margin:0 0 0 4px;}

#yiv7146606929 .yiv7146606929bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv7146606929 .yiv7146606929bold a {
text-decoration:none;}

#yiv7146606929 dd.yiv7146606929last p a {
font-family:Verdana;font-weight:700;}

#yiv7146606929 dd.yiv7146606929last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv7146606929 dd.yiv7146606929last p
span.yiv7146606929yshortcuts {
margin-right:0;}

#yiv7146606929 div.yiv7146606929attach-table div div a {
text-decoration:none;}

#yiv7146606929 div.yiv7146606929attach-table {
width:400px;}

#yiv7146606929 div.yiv7146606929file-title a, #yiv7146606929
div.yiv7146606929file-title a:active, #yiv7146606929
div.yiv7146606929file-title a:hover, #yiv7146606929
div.yiv7146606929file-title a:visited {
text-decoration:none;}

#yiv7146606929 div.yiv7146606929photo-title a,
#yiv7146606929 div.yiv7146606929photo-title a:active,
#yiv7146606929 div.yiv7146606929photo-title a:hover,
#yiv7146606929 div.yiv7146606929photo-title a:visited {
text-decoration:none;}

#yiv7146606929 div#yiv7146606929ygrp-mlmsg
#yiv7146606929ygrp-msg p a span.yiv7146606929yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv7146606929 .yiv7146606929green {
color:#628c2a;}

#yiv7146606929 .yiv7146606929MsoNormal {
margin:0 0 0 0;}

#yiv7146606929 o {
font-size:0;}

#yiv7146606929 #yiv7146606929photos div {
float:left;width:72px;}

#yiv7146606929 #yiv7146606929photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv7146606929 #yiv7146606929photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv7146606929 #yiv7146606929reco-category {
font-size:77%;}

#yiv7146606929 #yiv7146606929reco-desc {
font-size:77%;}

#yiv7146606929 .yiv7146606929replbq {
margin:4px;}

#yiv7146606929 #yiv7146606929ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv7146606929 #yiv7146606929ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv7146606929 #yiv7146606929ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv7146606929 #yiv7146606929ygrp-mlmsg select,
#yiv7146606929 input, #yiv7146606929 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv7146606929 #yiv7146606929ygrp-mlmsg pre, #yiv7146606929
code {
font:115% monospace;}

#yiv7146606929 #yiv7146606929ygrp-mlmsg * {
line-height:1.22em;}

#yiv7146606929 #yiv7146606929ygrp-mlmsg #yiv7146606929logo {
padding-bottom:10px;}


#yiv7146606929 #yiv7146606929ygrp-msg p a {
font-family:Verdana;}

#yiv7146606929 #yiv7146606929ygrp-msg
p#yiv7146606929attach-count span {
color:#1E66AE;font-weight:700;}

#yiv7146606929 #yiv7146606929ygrp-reco
#yiv7146606929reco-head {
color:#ff7900;font-weight:700;}

#yiv7146606929 #yiv7146606929ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv7146606929 #yiv7146606929ygrp-sponsor #yiv7146606929ov
li a {
font-size:130%;text-decoration:none;}

#yiv7146606929 #yiv7146606929ygrp-sponsor #yiv7146606929ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv7146606929 #yiv7146606929ygrp-sponsor #yiv7146606929ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv7146606929 #yiv7146606929ygrp-text {
font-family:Georgia;}

#yiv7146606929 #yiv7146606929ygrp-text p {
margin:0 0 1em 0;}

#yiv7146606929 #yiv7146606929ygrp-text tt {
font-size:120%;}

#yiv7146606929 #yiv7146606929ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv7146606929

Tue Jan 26, 2016 1:15 am (PST) . Posted by:

"Subroto, Matzen"

Dear Master

Mohon Pencerahannye dengan VB menemukan baris kosong di urutan paling akhir data

Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan

Terima Kasih

Matzen

Tue Jan 26, 2016 1:27 am (PST) . Posted by:

"Pauzan Ozan" b3ki_cot

Dear Para Master Be-Exceller

Mohon bantuan untuk problem yang saya alami
bgaimna VBA supaya saya dapat menampilkan judul header yg ad pada tabel ke listbox yang ada pd userform.(file terlampir)
Atas bantuannya Saya hanya bisa ucapin terima kasih saja

wassalam..
============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar