hallo Master HK.
Baru sadar Pak, payah dah,, kagak nyadar, hehehemakasih pak HK.
Pada Rabu, 10 Juli 2019 09.28.24 WIB, hendrik karnadi
hendrikkarn...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>
menulis:
Hai Fahmi,
Kalau dalam sepakbola namanya "Off Side").
Mengapa ?Krn penulisan nama Sheet di Worksheet dan VBE Sheet tidak sama
(Subscript out of range),di Worksheet ada spasi...di VBE Sheeet tidak ada spasi.
Salam,HK
Sent from Yahoo Mail on Android
On Wed, Jul 10, 2019 at 8:23, Fahmi Syaifullah fahmisyaifulla...@yahoo.com
[belajar-excel]<belajar-excel@yahoogroups.com> wrote:
assalamu'alaikum wr. wb
maaf ganggu beexceler.
mau tanya kenapa saya tulis makro tapi kok eror begini yaa padahal makronya
simple banget.kalau di workbook baru sih gak masalah lancar2 ajah. tapi kenapa
tempat yang ada makronya dia muncul error begini.
mohon infonya master..
terima kasih
wassalamu'alaikum wr.wb
#yiv1754247549 #yiv1754247549 -- #yiv1754247549ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1754247549
#yiv1754247549ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1754247549
#yiv1754247549ygrp-mkp #yiv1754247549hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1754247549 #yiv1754247549ygrp-mkp #yiv1754247549ads
{margin-bottom:10px;}#yiv1754247549 #yiv1754247549ygrp-mkp .yiv1754247549ad
{padding:0 0;}#yiv1754247549 #yiv1754247549ygrp-mkp .yiv1754247549ad p
{margin:0;}#yiv1754247549 #yiv1754247549ygrp-mkp .yiv1754247549ad a
{color:#0000ff;text-decoration:none;}#yiv1754247549 #yiv1754247549ygrp-sponsor
#yiv1754247549ygrp-lc {font-family:Arial;}#yiv1754247549
#yiv1754247549ygrp-sponsor #yiv1754247549ygrp-lc #yiv1754247549hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1754247549
#yiv1754247549ygrp-sponsor #yiv1754247549ygrp-lc .yiv1754247549ad
{margin-bottom:10px;padding:0 0;}#yiv1754247549 #yiv1754247549actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1754247549
#yiv1754247549activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1754247549
#yiv1754247549activity span {font-weight:700;}#yiv1754247549
#yiv1754247549activity span:first-child
{text-transform:uppercase;}#yiv1754247549 #yiv1754247549activity span a
{color:#5085b6;text-decoration:none;}#yiv1754247549 #yiv1754247549activity span
span {color:#ff7900;}#yiv1754247549 #yiv1754247549activity span
.yiv1754247549underline {text-decoration:underline;}#yiv1754247549
.yiv1754247549attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1754247549 .yiv1754247549attach div a
{text-decoration:none;}#yiv1754247549 .yiv1754247549attach img
{border:none;padding-right:5px;}#yiv1754247549 .yiv1754247549attach label
{display:block;margin-bottom:5px;}#yiv1754247549 .yiv1754247549attach label a
{text-decoration:none;}#yiv1754247549 blockquote {margin:0 0 0
4px;}#yiv1754247549 .yiv1754247549bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1754247549
.yiv1754247549bold a {text-decoration:none;}#yiv1754247549 dd.yiv1754247549last
p a {font-family:Verdana;font-weight:700;}#yiv1754247549 dd.yiv1754247549last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1754247549
dd.yiv1754247549last p span.yiv1754247549yshortcuts
{margin-right:0;}#yiv1754247549 div.yiv1754247549attach-table div div a
{text-decoration:none;}#yiv1754247549 div.yiv1754247549attach-table
{width:400px;}#yiv1754247549 div.yiv1754247549file-title a, #yiv1754247549
div.yiv1754247549file-title a:active, #yiv1754247549
div.yiv1754247549file-title a:hover, #yiv1754247549 div.yiv1754247549file-title
a:visited {text-decoration:none;}#yiv1754247549 div.yiv1754247549photo-title a,
#yiv1754247549 div.yiv1754247549photo-title a:active, #yiv1754247549
div.yiv1754247549photo-title a:hover, #yiv1754247549
div.yiv1754247549photo-title a:visited {text-decoration:none;}#yiv1754247549
div#yiv1754247549ygrp-mlmsg #yiv1754247549ygrp-msg p a
span.yiv1754247549yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1754247549
.yiv1754247549green {color:#628c2a;}#yiv1754247549 .yiv1754247549MsoNormal
{margin:0 0 0 0;}#yiv1754247549 o {font-size:0;}#yiv1754247549
#yiv1754247549photos div {float:left;width:72px;}#yiv1754247549
#yiv1754247549photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv1754247549
#yiv1754247549photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1754247549
#yiv1754247549reco-category {font-size:77%;}#yiv1754247549
#yiv1754247549reco-desc {font-size:77%;}#yiv1754247549 .yiv1754247549replbq
{margin:4px;}#yiv1754247549 #yiv1754247549ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1754247549 #yiv1754247549ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1754247549
#yiv1754247549ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1754247549
#yiv1754247549ygrp-mlmsg select, #yiv1754247549 input, #yiv1754247549 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1754247549
#yiv1754247549ygrp-mlmsg pre, #yiv1754247549 code {font:115%
monospace;}#yiv1754247549 #yiv1754247549ygrp-mlmsg *
{line-height:1.22em;}#yiv1754247549 #yiv1754247549ygrp-mlmsg #yiv1754247549logo
{padding-bottom:10px;}#yiv1754247549 #yiv1754247549ygrp-msg p a
{font-family:Verdana;}#yiv1754247549 #yiv1754247549ygrp-msg
p#yiv1754247549attach-count span {color:#1E66AE;font-weight:700;}#yiv1754247549
#yiv1754247549ygrp-reco #yiv1754247549reco-head
{color:#ff7900;font-weight:700;}#yiv1754247549 #yiv1754247549ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1754247549 #yiv1754247549ygrp-sponsor
#yiv1754247549ov li a {font-size:130%;text-decoration:none;}#yiv1754247549
#yiv1754247549ygrp-sponsor #yiv1754247549ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1754247549
#yiv1754247549ygrp-sponsor #yiv1754247549ov ul {margin:0;padding:0 0 0
8px;}#yiv1754247549 #yiv1754247549ygrp-text
{font-family:Georgia;}#yiv1754247549 #yiv1754247549ygrp-text p {margin:0 0 1em
0;}#yiv1754247549 #yiv1754247549ygrp-text tt {font-size:120%;}#yiv1754247549
#yiv1754247549ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1754247549
