dhdear pak toby dan rekan be excel
saya juga mempunyai kasus yang hampir mirip..tapi saya coba makro dari pak
toby.. misal nya data lebih banyak kok belum sesuai ya..ini kan data nya sampai
baris 449 tapi seandainya data sampai baris 600.baris yang ke 450 samapi 600
tdak ikut di eksekusi.
salam
liem
Pada Senin, 17 Agustus 2015 16:47, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
| Dear Ratri,Mungkin file ini bisa membantu.It's work in Office
2013.TerimaKasih.Sent from Yahoo Mail on Android |
From: Ratri Risyanto [email protected] [belajar-excel]
<[email protected]>;
To: <[email protected]>;
Subject: [belajar-excel] Loop tidak bisa berhenti [1 Attachment]
Sent: Sun, Aug 16, 2015 12:31:34 PM
| Dear all masterSaya mau meringkas data dg menghapus header hasil dr
convert pdf ke excel.. namun kendalanya macro saya loop tidak bisa
berhenti..Data terlampir:
Sheet AWAL merupakan data yg akan diproses
Sheet HASIL merupakan data hasil setelah proses (ini saya proses manual)
Macro ada di module1Mohon bantuannya agar macronya bisa berjalan dan berhenti
otomatis dan hasilnya sesuai sheet HASIL.Terima kasih
Risyanto |
#yiv5127193844 #yiv5127193844 -- #yiv5127193844ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5127193844
#yiv5127193844ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5127193844
#yiv5127193844ygrp-mkp #yiv5127193844hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5127193844 #yiv5127193844ygrp-mkp #yiv5127193844ads
{margin-bottom:10px;}#yiv5127193844 #yiv5127193844ygrp-mkp .yiv5127193844ad
{padding:0 0;}#yiv5127193844 #yiv5127193844ygrp-mkp .yiv5127193844ad p
{margin:0;}#yiv5127193844 #yiv5127193844ygrp-mkp .yiv5127193844ad a
{color:#0000ff;text-decoration:none;}#yiv5127193844 #yiv5127193844ygrp-sponsor
#yiv5127193844ygrp-lc {font-family:Arial;}#yiv5127193844
#yiv5127193844ygrp-sponsor #yiv5127193844ygrp-lc #yiv5127193844hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5127193844
#yiv5127193844ygrp-sponsor #yiv5127193844ygrp-lc .yiv5127193844ad
{margin-bottom:10px;padding:0 0;}#yiv5127193844 #yiv5127193844actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5127193844
#yiv5127193844activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5127193844
#yiv5127193844activity span {font-weight:700;}#yiv5127193844
#yiv5127193844activity span:first-child
{text-transform:uppercase;}#yiv5127193844 #yiv5127193844activity span a
{color:#5085b6;text-decoration:none;}#yiv5127193844 #yiv5127193844activity span
span {color:#ff7900;}#yiv5127193844 #yiv5127193844activity span
.yiv5127193844underline {text-decoration:underline;}#yiv5127193844
.yiv5127193844attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5127193844 .yiv5127193844attach div a
{text-decoration:none;}#yiv5127193844 .yiv5127193844attach img
{border:none;padding-right:5px;}#yiv5127193844 .yiv5127193844attach label
{display:block;margin-bottom:5px;}#yiv5127193844 .yiv5127193844attach label a
{text-decoration:none;}#yiv5127193844 blockquote {margin:0 0 0
4px;}#yiv5127193844 .yiv5127193844bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5127193844
.yiv5127193844bold a {text-decoration:none;}#yiv5127193844 dd.yiv5127193844last
p a {font-family:Verdana;font-weight:700;}#yiv5127193844 dd.yiv5127193844last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5127193844
dd.yiv5127193844last p span.yiv5127193844yshortcuts
{margin-right:0;}#yiv5127193844 div.yiv5127193844attach-table div div a
{text-decoration:none;}#yiv5127193844 div.yiv5127193844attach-table
{width:400px;}#yiv5127193844 div.yiv5127193844file-title a, #yiv5127193844
div.yiv5127193844file-title a:active, #yiv5127193844
div.yiv5127193844file-title a:hover, #yiv5127193844 div.yiv5127193844file-title
a:visited {text-decoration:none;}#yiv5127193844 div.yiv5127193844photo-title a,
#yiv5127193844 div.yiv5127193844photo-title a:active, #yiv5127193844
div.yiv5127193844photo-title a:hover, #yiv5127193844
div.yiv5127193844photo-title a:visited {text-decoration:none;}#yiv5127193844
div#yiv5127193844ygrp-mlmsg #yiv5127193844ygrp-msg p a
span.yiv5127193844yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5127193844
.yiv5127193844green {color:#628c2a;}#yiv5127193844 .yiv5127193844MsoNormal
{margin:0 0 0 0;}#yiv5127193844 o {font-size:0;}#yiv5127193844
#yiv5127193844photos div {float:left;width:72px;}#yiv5127193844
#yiv5127193844photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5127193844
#yiv5127193844photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5127193844
#yiv5127193844reco-category {font-size:77%;}#yiv5127193844
#yiv5127193844reco-desc {font-size:77%;}#yiv5127193844 .yiv5127193844replbq
{margin:4px;}#yiv5127193844 #yiv5127193844ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5127193844 #yiv5127193844ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5127193844
#yiv5127193844ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5127193844
#yiv5127193844ygrp-mlmsg select, #yiv5127193844 input, #yiv5127193844 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5127193844
#yiv5127193844ygrp-mlmsg pre, #yiv5127193844 code {font:115%
monospace;}#yiv5127193844 #yiv5127193844ygrp-mlmsg *
{line-height:1.22em;}#yiv5127193844 #yiv5127193844ygrp-mlmsg #yiv5127193844logo
{padding-bottom:10px;}#yiv5127193844 #yiv5127193844ygrp-msg p a
{font-family:Verdana;}#yiv5127193844 #yiv5127193844ygrp-msg
p#yiv5127193844attach-count span {color:#1E66AE;font-weight:700;}#yiv5127193844
#yiv5127193844ygrp-reco #yiv5127193844reco-head
{color:#ff7900;font-weight:700;}#yiv5127193844 #yiv5127193844ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5127193844 #yiv5127193844ygrp-sponsor
#yiv5127193844ov li a {font-size:130%;text-decoration:none;}#yiv5127193844
#yiv5127193844ygrp-sponsor #yiv5127193844ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5127193844
#yiv5127193844ygrp-sponsor #yiv5127193844ov ul {margin:0;padding:0 0 0
8px;}#yiv5127193844 #yiv5127193844ygrp-text
{font-family:Georgia;}#yiv5127193844 #yiv5127193844ygrp-text p {margin:0 0 1em
0;}#yiv5127193844 #yiv5127193844ygrp-text tt {font-size:120%;}#yiv5127193844
#yiv5127193844ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5127193844
