Jumat, 02 Desember 2016

[belajar-excel] Digest Number 4035

5 Messages

Digest #4035
1a
Bls: [belajar-excel] pindah data by "Toby kenzo" tobykenzo
1b
Re: pindah data by "dwint ruswanto"
2
Variable Scope by "Febry Ferian" febryferian

Messages

Thu Dec 1, 2016 2:39 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Hendro,
Coba buat commandButton baru dan masukan script ini:
Dim a, b As Integer
a = 5
b = 1
Sheet1.Activate
Do While b <= aSheet1.Cells(19 + b, 2).Value = Sheet7.Cells(b, 1).Value
Sheet1.Cells(19 + b, 8).Value = Sheet7.Cells(5 + b, 1).Value
Sheet1.Cells(19 + b, 4).Value = Sheet7.Cells(b, 2).Value
Sheet1.Cells(19 + b, 10).Value = Sheet7.Cells(5 + b, 2).Value
Sheet1.Cells(19 + b, 5).Value = Sheet7.Cells(b, 3).Value
Sheet1.Cells(19 + b, 12).Value = Sheet7.Cells(5 + b, 3).Valueb = b + 1
Loop
Semoga membantu.
TerimaKasih. 

Pada Kamis, 1 Desember 2016 16:26, "'Hendro@daya-motor' hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  maaf bp.toby bisa kasih saya contoh nya..soalnya saya sdh mencoba pakai
loop saya belum berhasil..dan sampai sekarang masih blm tau juga harus pakai
loop yg apa?maaf baru belajar.

----- Original Message -----
From: "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: <belajar-excel@yahoogroups.com>
Sent: Thursday, December 01, 2016 3:10 PM
Subject: Bls: [belajar-excel] pindah data

Dear Hendro,
Anda bisa menggunakan "Loop" method
TerimaKasih.

Pada Selasa, 29 November 2016 17:45, "Hendro Arifin
hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:

selamat sore mr.kid dan rekan2..mohon bantuan untuk solusi berikut.saya
bermaksud memindahkan data dari sheet list_ho ke sheet dt_ print dimana
list_ho adalahhasil dari advance filter yang jumlah baris nya akan selalu
berubah tiap kali tonbol print di tekan tetapi jumlah
tidak lebih dari 10 baris dan dengan jumlah kolom tetap yaitu 3 kolom.saya
mempunyai kode macro tetapisaya merasa kode saya tersebut terlalu
panjang.bisakah kode saya tersebut di persingkat?atokah ada kode
lain untuk menggantikan kode macro saya tersebut?mohon petunjukanyaterima
kasih.

salam hendro

#yiv4553733650 #yiv4553733650 -- #yiv4553733650ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4553733650
#yiv4553733650ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4553733650
#yiv4553733650ygrp-mkp #yiv4553733650hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4553733650 #yiv4553733650ygrp-mkp #yiv4553733650ads
{margin-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad
{padding:0 0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad p
{margin:0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad a
{color:#0000ff;text-decoration:none;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc
{font-family:Arial;}#yiv4553733650 #yiv4553733650ygrp-sponsor
#yiv4553733650ygrp-lc #yiv4553733650hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc .yiv4553733650ad
{margin-bottom:10px;padding:0 0;}#yiv4553733650 #yiv4553733650actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4553733650
#yiv4553733650activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4553733650
#yiv4553733650activity span {font-weight:700;}#yiv4553733650
#yiv4553733650activity span:first-child
{text-transform:uppercase;}#yiv4553733650 #yiv4553733650activity span a
{color:#5085b6;text-decoration:none;}#yiv4553733650 #yiv4553733650activity
span span {color:#ff7900;}#yiv4553733650 #yiv4553733650activity span
.yiv4553733650underline {text-decoration:underline;}#yiv4553733650
.yiv4553733650attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4553733650 .yiv4553733650attach div a
{text-decoration:none;}#yiv4553733650 .yiv4553733650attach img
{border:none;padding-right:5px;}#yiv4553733650 .yiv4553733650attach label
{display:block;margin-bottom:5px;}#yiv4553733650 .yiv4553733650attach label
a {text-decoration:none;}#yiv4553733650 blockquote {margin:0 0 0
4px;}#yiv4553733650 .yiv4553733650bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4553733650
.yiv4553733650bold a {text-decoration:none;}#yiv4553733650
dd.yiv4553733650last p a
{font-family:Verdana;font-weight:700;}#yiv4553733650 dd.yiv4553733650last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4553733650
dd.yiv4553733650last p span.yiv4553733650yshortcuts
{margin-right:0;}#yiv4553733650 div.yiv4553733650attach-table div div a
{text-decoration:none;}#yiv4553733650 div.yiv4553733650attach-table
{width:400px;}#yiv4553733650 div.yiv4553733650file-title a, #yiv4553733650
div.yiv4553733650file-title a:active, #yiv4553733650
div.yiv4553733650file-title a:hover, #yiv4553733650
div.yiv4553733650file-title a:visited {text-decoration:none;}#yiv4553733650
div.yiv4553733650photo-title a, #yiv4553733650 div.yiv4553733650photo-title
a:active, #yiv4553733650 div.yiv4553733650photo-title a:hover,
#yiv4553733650 div.yiv4553733650photo-title a:visited
{text-decoration:none;}#yiv4553733650 div#yiv4553733650ygrp-mlmsg
#yiv4553733650ygrp-msg p a span.yiv4553733650yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4553733650
.yiv4553733650green {color:#628c2a;}#yiv4553733650 .yiv4553733650MsoNormal
{margin:0 0 0 0;}#yiv4553733650 o {font-size:0;}#yiv4553733650
#yiv4553733650photos div {float:left;width:72px;}#yiv4553733650
#yiv4553733650photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4553733650
#yiv4553733650photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4553733650
#yiv4553733650reco-category {font-size:77%;}#yiv4553733650
#yiv4553733650reco-desc {font-size:77%;}#yiv4553733650 .yiv4553733650replbq
{margin:4px;}#yiv4553733650 #yiv4553733650ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4553733650 #yiv4553733650ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg table
{font-size:inherit;font:100%;}#yiv4553733650 #yiv4553733650ygrp-mlmsg
select, #yiv4553733650 input, #yiv4553733650 textarea {font:99% Arial,
Helvetica, clean, sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg pre,
#yiv4553733650 code {font:115% monospace;}#yiv4553733650
#yiv4553733650ygrp-mlmsg * {line-height:1.22em;}#yiv4553733650
#yiv4553733650ygrp-mlmsg #yiv4553733650logo
{padding-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-msg p a
{font-family:Verdana;}#yiv4553733650 #yiv4553733650ygrp-msg
p#yiv4553733650attach-count span
{color:#1E66AE;font-weight:700;}#yiv4553733650 #yiv4553733650ygrp-reco
#yiv4553733650reco-head {color:#ff7900;font-weight:700;}#yiv4553733650
#yiv4553733650ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ov li a
{font-size:130%;text-decoration:none;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4553733650
#yiv4553733650ygrp-sponsor #yiv4553733650ov ul {margin:0;padding:0 0 0
8px;}#yiv4553733650 #yiv4553733650ygrp-text
{font-family:Georgia;}#yiv4553733650 #yiv4553733650ygrp-text p {margin:0 0
1em 0;}#yiv4553733650 #yiv4553733650ygrp-text tt
{font-size:120%;}#yiv4553733650 #yiv4553733650ygrp-vital ul li:last-child
{border-right:none !important;}#yiv4553733650

#yiv4177498898 #yiv4177498898 -- #yiv4177498898ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4177498898 #yiv4177498898ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4177498898 #yiv4177498898ygrp-mkp #yiv4177498898hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4177498898 #yiv4177498898ygrp-mkp #yiv4177498898ads {margin-bottom:10px;}#yiv4177498898 #yiv4177498898ygrp-mkp .yiv4177498898ad {padding:0 0;}#yiv4177498898 #yiv4177498898ygrp-mkp .yiv4177498898ad p {margin:0;}#yiv4177498898 #yiv4177498898ygrp-mkp .yiv4177498898ad a {color:#0000ff;text-decoration:none;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ygrp-lc {font-family:Arial;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ygrp-lc #yiv4177498898hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ygrp-lc .yiv4177498898ad {margin-bottom:10px;padding:0 0;}#yiv4177498898 #yiv4177498898actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4177498898 #yiv4177498898activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4177498898 #yiv4177498898activity span {font-weight:700;}#yiv4177498898 #yiv4177498898activity span:first-child {text-transform:uppercase;}#yiv4177498898 #yiv4177498898activity span a {color:#5085b6;text-decoration:none;}#yiv4177498898 #yiv4177498898activity span span {color:#ff7900;}#yiv4177498898 #yiv4177498898activity span .yiv4177498898underline {text-decoration:underline;}#yiv4177498898 .yiv4177498898attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4177498898 .yiv4177498898attach div a {text-decoration:none;}#yiv4177498898 .yiv4177498898attach img {border:none;padding-right:5px;}#yiv4177498898 .yiv4177498898attach label {display:block;margin-bottom:5px;}#yiv4177498898 .yiv4177498898attach label a {text-decoration:none;}#yiv4177498898 blockquote {margin:0 0 0 4px;}#yiv4177498898 .yiv4177498898bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4177498898 .yiv4177498898bold a {text-decoration:none;}#yiv4177498898 dd.yiv4177498898last p a {font-family:Verdana;font-weight:700;}#yiv4177498898 dd.yiv4177498898last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4177498898 dd.yiv4177498898last p span.yiv4177498898yshortcuts {margin-right:0;}#yiv4177498898 div.yiv4177498898attach-table div div a {text-decoration:none;}#yiv4177498898 div.yiv4177498898attach-table {width:400px;}#yiv4177498898 div.yiv4177498898file-title a, #yiv4177498898 div.yiv4177498898file-title a:active, #yiv4177498898 div.yiv4177498898file-title a:hover, #yiv4177498898 div.yiv4177498898file-title a:visited {text-decoration:none;}#yiv4177498898 div.yiv4177498898photo-title a, #yiv4177498898 div.yiv4177498898photo-title a:active, #yiv4177498898 div.yiv4177498898photo-title a:hover, #yiv4177498898 div.yiv4177498898photo-title a:visited {text-decoration:none;}#yiv4177498898 div#yiv4177498898ygrp-mlmsg #yiv4177498898ygrp-msg p a span.yiv4177498898yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4177498898 .yiv4177498898green {color:#628c2a;}#yiv4177498898 .yiv4177498898MsoNormal {margin:0 0 0 0;}#yiv4177498898 o {font-size:0;}#yiv4177498898 #yiv4177498898photos div {float:left;width:72px;}#yiv4177498898 #yiv4177498898photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4177498898 #yiv4177498898photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4177498898 #yiv4177498898reco-category {font-size:77%;}#yiv4177498898 #yiv4177498898reco-desc {font-size:77%;}#yiv4177498898 .yiv4177498898replbq {margin:4px;}#yiv4177498898 #yiv4177498898ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4177498898 #yiv4177498898ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4177498898 #yiv4177498898ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4177498898 #yiv4177498898ygrp-mlmsg select, #yiv4177498898 input, #yiv4177498898 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4177498898 #yiv4177498898ygrp-mlmsg pre, #yiv4177498898 code {font:115% monospace;}#yiv4177498898 #yiv4177498898ygrp-mlmsg * {line-height:1.22em;}#yiv4177498898 #yiv4177498898ygrp-mlmsg #yiv4177498898logo {padding-bottom:10px;}#yiv4177498898 #yiv4177498898ygrp-msg p a {font-family:Verdana;}#yiv4177498898 #yiv4177498898ygrp-msg p#yiv4177498898attach-count span {color:#1E66AE;font-weight:700;}#yiv4177498898 #yiv4177498898ygrp-reco #yiv4177498898reco-head {color:#ff7900;font-weight:700;}#yiv4177498898 #yiv4177498898ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ov li a {font-size:130%;text-decoration:none;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4177498898 #yiv4177498898ygrp-sponsor #yiv4177498898ov ul {margin:0;padding:0 0 0 8px;}#yiv4177498898 #yiv4177498898ygrp-text {font-family:Georgia;}#yiv4177498898 #yiv4177498898ygrp-text p {margin:0 0 1em 0;}#yiv4177498898 #yiv4177498898ygrp-text tt {font-size:120%;}#yiv4177498898 #yiv4177498898ygrp-vital ul li:last-child {border-right:none !important;}#yiv4177498898

Thu Dec 1, 2016 2:48 am (PST) . Posted by:

"dwint ruswanto"

Dear rekans,

sedikit menambahkan,

Dim a, b As Integer

akan menghasilkan:
variabel a dengan type data Variant
variabel b dengan type data Integer

maaf belum sempat ngintip filenya jadi tidak bisa ikutan solusi.

Wassalam,

-dwint-

2016-12-01 17:32 GMT+07:00 Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com>:

>
>
> Dear Hendro,
>
> Coba buat commandButton baru dan masukan script ini:
>
> Dim a, b As Integer
> a = 5
> b = 1
>
> Sheet1.Activate
>
> Do While b <= a
> Sheet1.Cells(19 + b, 2).Value = Sheet7.Cells(b, 1).Value
> Sheet1.Cells(19 + b, 8).Value = Sheet7.Cells(5 + b, 1).Value
> Sheet1.Cells(19 + b, 4).Value = Sheet7.Cells(b, 2).Value
> Sheet1.Cells(19 + b, 10).Value = Sheet7.Cells(5 + b, 2).Value
> Sheet1.Cells(19 + b, 5).Value = Sheet7.Cells(b, 3).Value
> Sheet1.Cells(19 + b, 12).Value = Sheet7.Cells(5 + b, 3).Value
> b = b + 1
> Loop
>
> Semoga membantu.
>
> TerimaKasih.
>
>
> Pada Kamis, 1 Desember 2016 16:26, "'Hendro@daya-motor'
> hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> menulis:
>
>
>
> maaf bp.toby bisa kasih saya contoh nya..soalnya saya sdh mencoba pakai
> loop saya belum berhasil..dan sampai sekarang masih blm tau juga harus
> pakai
> loop yg apa?maaf baru belajar.
>
> ----- Original Message -----
> From: "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]"
> <belajar-excel@yahoogroups.com>
> To: <belajar-excel@yahoogroups.com>
> Sent: Thursday, December 01, 2016 3:10 PM
> Subject: Bls: [belajar-excel] pindah data
>
> Dear Hendro,
> Anda bisa menggunakan "Loop" method
> TerimaKasih.
>
> Pada Selasa, 29 November 2016 17:45, "Hendro Arifin
> hendro_arifin@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
> menulis:
>
> selamat sore mr.kid dan rekan2..mohon bantuan untuk solusi berikut.saya
> bermaksud memindahkan data dari sheet list_ho ke sheet dt_ print dimana
> list_ho adalahhasil dari advance filter yang jumlah baris nya akan selalu
> berubah tiap kali tonbol print di tekan tetapi jumlah
> tidak lebih dari 10 baris dan dengan jumlah kolom tetap yaitu 3 kolom.saya
> mempunyai kode macro tetapisaya merasa kode saya tersebut terlalu
> panjang.bisakah kode saya tersebut di persingkat?atokah ada kode
> lain untuk menggantikan kode macro saya tersebut?mohon petunjukanyaterima
> kasih.
>
> salam hendro
>
> #yiv4553733650 #yiv4553733650 -- #yiv4553733650ygrp-mkp {border:1px
> solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
> 10px;}#yiv4553733650
> #yiv4553733650ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4553733650
> #yiv4553733650ygrp-mkp #yiv4553733650hd
> {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
> 0;}#yiv4553733650 #yiv4553733650ygrp-mkp #yiv4553733650ads
> {margin-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-mkp
> .yiv4553733650ad
> {padding:0 0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad p
> {margin:0;}#yiv4553733650 #yiv4553733650ygrp-mkp .yiv4553733650ad a
> {color:#0000ff;text-decoration:none;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc
> {font-family:Arial;}#yiv4553733650 #yiv4553733650ygrp-sponsor
> #yiv4553733650ygrp-lc #yiv4553733650hd {margin:10px
> 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ygrp-lc .yiv4553733650ad
> {margin-bottom:10px;padding:0 0;}#yiv4553733650 #yiv4553733650actions
> {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4553733650
> #yiv4553733650activity
> {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4553733650
>
> #yiv4553733650activity span {font-weight:700;}#yiv4553733650
> #yiv4553733650activity span:first-child
> {text-transform:uppercase;}#yiv4553733650 #yiv4553733650activity span a
> {color:#5085b6;text-decoration:none;}#yiv4553733650
> #yiv4553733650activity
> span span {color:#ff7900;}#yiv4553733650 #yiv4553733650activity span
> .yiv4553733650underline {text-decoration:underline;}#yiv4553733650
> .yiv4553733650attach
> {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
> 0;width:400px;}#yiv4553733650 .yiv4553733650attach div a
> {text-decoration:none;}#yiv4553733650 .yiv4553733650attach img
> {border:none;padding-right:5px;}#yiv4553733650 .yiv4553733650attach label
> {display:block;margin-bottom:5px;}#yiv4553733650 .yiv4553733650attach
> label
> a {text-decoration:none;}#yiv4553733650 blockquote {margin:0 0 0
> 4px;}#yiv4553733650 .yiv4553733650bold
> {font-family:Arial;font-size:13px;font-weight:700;}#yiv4553733650
> .yiv4553733650bold a {text-decoration:none;}#yiv4553733650
> dd.yiv4553733650last p a
> {font-family:Verdana;font-weight:700;}#yiv4553733650 dd.yiv4553733650last
> p
> span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4553733650
>
> dd.yiv4553733650last p span.yiv4553733650yshortcuts
> {margin-right:0;}#yiv4553733650 div.yiv4553733650attach-table div div a
> {text-decoration:none;}#yiv4553733650 div.yiv4553733650attach-table
> {width:400px;}#yiv4553733650 div.yiv4553733650file-title a, #yiv4553733650
> div.yiv4553733650file-title a:active, #yiv4553733650
> div.yiv4553733650file-title a:hover, #yiv4553733650
> div.yiv4553733650file-title a:visited {text-decoration:none;}#yiv4553733650
>
> div.yiv4553733650photo-title a, #yiv4553733650
> div.yiv4553733650photo-title
> a:active, #yiv4553733650 div.yiv4553733650photo-title a:hover,
> #yiv4553733650 div.yiv4553733650photo-title a:visited
> {text-decoration:none;}#yiv4553733650 div#yiv4553733650ygrp-mlmsg
> #yiv4553733650ygrp-msg p a span.yiv4553733650yshortcuts
> {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4553733650
> .yiv4553733650green {color:#628c2a;}#yiv4553733650 .yiv4553733650MsoNormal
> {margin:0 0 0 0;}#yiv4553733650 o {font-size:0;}#yiv4553733650
> #yiv4553733650photos div {float:left;width:72px;}#yiv4553733650
> #yiv4553733650photos div div {border:1px solid
> #666666;height:62px;overflow:hidden;width:62px;}#yiv4553733650
> #yiv4553733650photos div label
> {color:#666666;font-size:10px;overflow:hidden;text-align:
> center;white-space:nowrap;width:64px;}#yiv4553733650
> #yiv4553733650reco-category {font-size:77%;}#yiv4553733650
> #yiv4553733650reco-desc {font-size:77%;}#yiv4553733650
> .yiv4553733650replbq
> {margin:4px;}#yiv4553733650 #yiv4553733650ygrp-actbar div a:first-child
> {margin-right:2px;padding-right:5px;}#yiv4553733650
> #yiv4553733650ygrp-mlmsg
> {font-size:13px;font-family:Arial, helvetica, clean,
> sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg table
> {font-size:inherit;font:100%;}#yiv4553733650 #yiv4553733650ygrp-mlmsg
> select, #yiv4553733650 input, #yiv4553733650 textarea {font:99% Arial,
> Helvetica, clean, sans-serif;}#yiv4553733650 #yiv4553733650ygrp-mlmsg pre,
> #yiv4553733650 code {font:115% monospace;}#yiv4553733650
> #yiv4553733650ygrp-mlmsg * {line-height:1.22em;}#yiv4553733650
> #yiv4553733650ygrp-mlmsg #yiv4553733650logo
> {padding-bottom:10px;}#yiv4553733650 #yiv4553733650ygrp-msg p a
> {font-family:Verdana;}#yiv4553733650 #yiv4553733650ygrp-msg
> p#yiv4553733650attach-count span
> {color:#1E66AE;font-weight:700;}#yiv4553733650 #yiv4553733650ygrp-reco
> #yiv4553733650reco-head {color:#ff7900;font-weight:700;}#yiv4553733650
> #yiv4553733650ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ov li a
> {font-size:130%;text-decoration:none;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ov li
> {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4553733650
> #yiv4553733650ygrp-sponsor #yiv4553733650ov ul {margin:0;padding:0 0 0
> 8px;}#yiv4553733650 #yiv4553733650ygrp-text
> {font-family:Georgia;}#yiv4553733650 #yiv4553733650ygrp-text p {margin:0
> 0
> 1em 0;}#yiv4553733650 #yiv4553733650ygrp-text tt
> {font-size:120%;}#yiv4553733650 #yiv4553733650ygrp-vital ul li:last-child
> {border-right:none !important;}#yiv4553733650
>
>
>
>
>

Thu Dec 1, 2016 3:52 am (PST) . Posted by:

"Febry Ferian" febryferian

Selamat sore rekan dan admin belajar excel,
Saya mengalami kesulitan dalam menemukan jawaban atas error dalam percobaan variable scope yg saya coba latih. Kebetulan saya dalam tahap mempelajari macro dari tahap dasar, namun mentok di tahap ini karena apa yg diinstruksikan di buku tidak berhasil ketika saya lakukan.
Saya lampirkan contoh macro yg saya buat.
Saya sedang mencoba untuk input value pada sheet satu, secara berurutan utk subrutin InputData dan TambahDataBuku pada module vbBuku. Tadinya subrutin tsb terletak di module vbSeleksiSel, namun muncul error, "Only comment may appear at end sub, etc." Ketika dipindahkan ke module vbBuku, data yg saya input malah tidak berhasil masuk sesuai yg diharapkan.
Mohon bantuannya. Terima kasih.

Sent from Yahoo Mail on Android

Thu Dec 1, 2016 4:02 am (PST) . Posted by:

cheivory_bridge

Yth. Mr. Kid

Mohon pencerahannya atas vba merger file tersebut.
Saya coba terapkan pada beberapa file yang berisi banyak sheet, belum berhasil.
kondisinya :
- saya punya 30an file workbook dengan 20 sheet tiap workbook (nama tiap sheetnya SAMA antar workbook).
- saya ingin menggabungkan data yang ada pada sheet "Nilai per DM" pada setiap workbook tersebut ke dalam workbaru baru.
- saya coba dengan vba merge file punya Mr. Kid belum berhasil. coba saya cari di kode vba yang menunjukkan rujukan untuk nama sheet sumber ("Nilai per DM") belum ketemu - kalau di file Mr. Kid , nama sheet sumber tiap workbook kan "Sales" ..


mohon kiranya diberi tahu, di bagian mana dari kode vba merge file tersebut yang mesti disesuaikan ..


terima kasih

Thu Dec 1, 2016 6:49 pm (PST) . Posted by:

"Susilo -"

Dear Zerlinda

Saya masih mencoba-coba dengan apa yang dimaksud oleh attachment

Untuk perpindahan data dari notepad ke excel (dan sebaliknya) saya
menggunakan copy paste
Rumus yang saya gunakan hanya mengikuti bentuk hasilnya saja

Sebenernya rumusnya bisa saja salah. Saya hanya ingin ada komen:
- maksud saya tidak begitu
- seharusnya kan kalau yang ini begini jadinya begini
- kalau datanya begini harusnya hasilnya begitu

dsb dsb semakin banyak persyaratan akan semakin mudah identifikasi soal

Terima kasih
Susilo

Pada 1 Desember 2016 13.29, Zerlinda Seismica seismica@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

>
>
> Assalamualaikum wrwb
>
> Rasanya ilmu excel ini akan senantiasa haus untuk dipelajari...
> problem ini tergolong sangat baru buat saya untuk melakukan perhitungan di
> excel tapi data berada di file txt
> berikut saya kirimkan data dengan kronologisnya.
> Terima kasih untuk berkenan mebaca dan bantuannya
>
> Wassalam
> Seismica
>
> --- Mods ---
> File lampiran yang melebihi 250KB dilepas dari email. Silakan melampirkan
> ulang file berukuran maksimal 250KB dengan cara me-reply email ini.
> ------------
>
>
>
============================================================
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
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 02.08 0 komentar

[smf_addin] Digest Number 3857[6 Attachments]

3 Messages

Digest #3857

Messages

Thu Dec 1, 2016 10:42 am (PST) . Posted by:

coreyjhansen

Excel: 2013
Windows 7 64-bit
SMF template: Yahoo Key Statistics


I have followed the Youtube video directions for using Find and Replace to remove hard-coded links with no success. The hard-coded pathway is removed from the link and the formula in each cell displays exactly as shown in the video. After clicking "replace All" the cell values all change to 0 but then revert to #NAME! as soon as the Find and Replace completes.


Please see the attached screenshots. I appreciate your time ad consideration in helping me solve this problem.


Corey




Attachment(s) from
6 of 6 Photo(s)

Thu Dec 1, 2016 10:59 am (PST) . Posted by:

coreyjhansen

Thank you for your time and consideration in replying.

My apologies. It appears my company has migrated to Excel 2016. Does this change your corrective action?

Thu Dec 1, 2016 11:50 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's Microsoft's suggestion, not mine. I'm not sure if that is your problem
or not. I only have EXCEL 2007, so can't answer what happens with other
versions of EXCEL.

I know before the work-around from Microsoft was released, some people had
to uncheck and recheck the add-in every time they started up EXCEL, or it
wasn't really loaded.

On Thu, Dec 1, 2016 at 11:59 AM, coreyjhansen@
​...wrote:

>
> My apologies. It appears my company has migrated to Excel 2016. Does this
> change your corrective action?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 02.00 0 komentar

]] XL-mania [[ Digest Number 2855

1 Message

Digest #2855

Message

Thu Dec 1, 2016 6:34 am (PST) . Posted by:



File : all_about_XL-mania.zip
Description : Kirimkan ke teman-teman Anda dan ajak mereka bergabung dengan lebih dari 16,000 member XL-mania!

:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, pembicaraan pribadi, one line message,  melecehkan,  tidak sopan.
:: ------------- ::::::::::::::::::::
Buat subjek yang kreatif, jangan : &quot;tanya&quot;, &quot;help&quot;, &quot;mohon bantu&quot;
Usahakan besar attachment &lt; 200 kb. Gunakan  winzip  jika  perlu.
:: ------------- ::::::::::::::::::::
Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke
XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari
http://groups.yahoo.com/group/XL-mania/files/Promotion/         
:: ------------- ::::::::::::::::::::
Berikan testimoni di : 
http://www.xl-mania.com/2008/06/testimoni-xl-mania.html        
:: ------------- ::::::::::::::::::::
Message lama ada di :
http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]
http://www.mail-archive.com/xl-mania@yahoogroups.com
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 01.52 0 komentar

Kamis, 01 Desember 2016

[ExcelVBA] File - GroupInfo.txt

 


This automatic email is posted to this group each month for the benefit of new members and as a reminder to current members.

NOTICE VERSION: January, 2012

* This group is monitored by several moderators. In an effort to help weed out spammers, most posts are manually verified before they are released

to the group. Therefore, if you are new to the group or do not regularly participate, it may take a bit longer for your post to show up in the

group. This is normal. We do try to keep watch and release valid posts ASAP. Once you become a recognized/active member of the group, we try to

make sure your membership is validated so that your posts can slide through without monitoring delays.

* Although we do try to keep posts on topic, we also like to be a friendly, community group here, so the occasional chatter between members is not

a problem. If you have something important to post that is "off topic"...please start the subject with OT-, as in "Off Topic" so that it can be

filtered out by those not wishing to be bothered by off topic posts.

* PLAY NICE! Verbal bashing of any kind will NOT be tolerated! If you have a problem with someone in this group...take it outside. If a complaint

is reported about your behavior, you'll be banned from the group...NO questions asked!

* This group has a web site. To locate the URL to the group's web page, see the bottom of any post where additional information is listed. Within

the group's web site, you'll find additional information. Depending on the activity/participation of the group, you may find additional help files

and/or tutorials, as well as other helpful links.

* Sadly, due to spammers, only moderators can post files and links within our group's site. However, if you have something you'd like to

contribute, contact one of the moderators...whose names are listed on the home page of our group's web page.

* Additionally, you cannot attach files to posts...again due to spammers. But if you have a file that you'd like others to see in an attempt to

help you solve a problem, contact a moderator to post the file for you. If you have any trouble contacting a moderator, feel free to request help

by posting to the group with the subject NEED MODERATOR HELP. (By using that EXACT subject, moderators can set an alert to more quickly notice your

post.)

* To get the best help, fast, use a good subject line! Don't just post a subject saying HELP! Give a little detail about the type of help you need.

Also be sure to include some details, such as the content of any error messages, as well as the software version you are using. For more specific

info on how to get the most from your posts, see this link: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=507#info

* With the help of several wonderful moderators and terrific group participants who regularly share their knowledge, I run a handful of free

support groups. To find our other groups, as well as other groups I recommend for free support, see this link:

http://www.mousetrax.com/resources.html

* And finally, know that you can find many free tutorials linked from my TechPage here: http://www.mousetrax.com/techpage.html and also directly

through TechTrax, my very popular, free ezine (online magazine) here: http://www.techtrax.us

Dian D. Chapman (Group Owner)
Technical Consultant, Microsoft MVP
MOS Certified Instructor, Editor/TechTrax Ezine
Tech Editor for Word & Office 2007 Bibles
https://mvp.support.microsoft.com/profile/Dian.Chapman

Dian's Soldier/K9 Site
http://www.mousetrax.com/dian/angels.html

Free Computer Tutorials: http://www.techtrax.us
Dian's Free User Support Groups: http://www.mousetrax.com/resources.html
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html

__._,_.___
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (121)
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 04.49 0 komentar
Langganan: Postingan (Atom)