[belajar-excel] Runtime error [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Runtime error [1 Attachment]

fahmi syaifullah
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


1562721597736blob.jpg (90K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Runtime error

hendrik karnadi
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 [hidden email] [belajar-excel]<[hidden email]> 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

  #yiv5143963189 #yiv5143963189 -- #yiv5143963189ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5143963189 #yiv5143963189ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5143963189 #yiv5143963189ygrp-mkp #yiv5143963189hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5143963189 #yiv5143963189ygrp-mkp #yiv5143963189ads {margin-bottom:10px;}#yiv5143963189 #yiv5143963189ygrp-mkp .yiv5143963189ad {padding:0 0;}#yiv5143963189 #yiv5143963189ygrp-mkp .yiv5143963189ad p {margin:0;}#yiv5143963189 #yiv5143963189ygrp-mkp .yiv5143963189ad a {color:#0000ff;text-decoration:none;}#yiv5143963189 #yiv5143963189ygrp-sponsor #yiv5143963189ygrp-lc {font-family:Arial;}#yiv5143963189 #yiv5143963189ygrp-sponsor #yiv5143963189ygrp-lc #yiv5143963189hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5143963189 #yiv5143963189ygrp-sponsor #yiv5143963189ygrp-lc .yiv5143963189ad {margin-bottom:10px;padding:0 0;}#yiv5143963189 #yiv5143963189actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5143963189 #yiv5143963189activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5143963189 #yiv5143963189activity span {font-weight:700;}#yiv5143963189 #yiv5143963189activity span:first-child {text-transform:uppercase;}#yiv5143963189 #yiv5143963189activity span a {color:#5085b6;text-decoration:none;}#yiv5143963189 #yiv5143963189activity span span {color:#ff7900;}#yiv5143963189 #yiv5143963189activity span .yiv5143963189underline {text-decoration:underline;}#yiv5143963189 .yiv5143963189attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5143963189 .yiv5143963189attach div a {text-decoration:none;}#yiv5143963189 .yiv5143963189attach img {border:none;padding-right:5px;}#yiv5143963189 .yiv5143963189attach label {display:block;margin-bottom:5px;}#yiv5143963189 .yiv5143963189attach label a {text-decoration:none;}#yiv5143963189 blockquote {margin:0 0 0 4px;}#yiv5143963189 .yiv5143963189bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5143963189 .yiv5143963189bold a {text-decoration:none;}#yiv5143963189 dd.yiv5143963189last p a {font-family:Verdana;font-weight:700;}#yiv5143963189 dd.yiv5143963189last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5143963189 dd.yiv5143963189last p span.yiv5143963189yshortcuts {margin-right:0;}#yiv5143963189 div.yiv5143963189attach-table div div a {text-decoration:none;}#yiv5143963189 div.yiv5143963189attach-table {width:400px;}#yiv5143963189 div.yiv5143963189file-title a, #yiv5143963189 div.yiv5143963189file-title a:active, #yiv5143963189 div.yiv5143963189file-title a:hover, #yiv5143963189 div.yiv5143963189file-title a:visited {text-decoration:none;}#yiv5143963189 div.yiv5143963189photo-title a, #yiv5143963189 div.yiv5143963189photo-title a:active, #yiv5143963189 div.yiv5143963189photo-title a:hover, #yiv5143963189 div.yiv5143963189photo-title a:visited {text-decoration:none;}#yiv5143963189 div#yiv5143963189ygrp-mlmsg #yiv5143963189ygrp-msg p a span.yiv5143963189yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5143963189 .yiv5143963189green {color:#628c2a;}#yiv5143963189 .yiv5143963189MsoNormal {margin:0 0 0 0;}#yiv5143963189 o {font-size:0;}#yiv5143963189 #yiv5143963189photos div {float:left;width:72px;}#yiv5143963189 #yiv5143963189photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5143963189 #yiv5143963189photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5143963189 #yiv5143963189reco-category {font-size:77%;}#yiv5143963189 #yiv5143963189reco-desc {font-size:77%;}#yiv5143963189 .yiv5143963189replbq {margin:4px;}#yiv5143963189 #yiv5143963189ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5143963189 #yiv5143963189ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5143963189 #yiv5143963189ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5143963189 #yiv5143963189ygrp-mlmsg select, #yiv5143963189 input, #yiv5143963189 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5143963189 #yiv5143963189ygrp-mlmsg pre, #yiv5143963189 code {font:115% monospace;}#yiv5143963189 #yiv5143963189ygrp-mlmsg * {line-height:1.22em;}#yiv5143963189 #yiv5143963189ygrp-mlmsg #yiv5143963189logo {padding-bottom:10px;}#yiv5143963189 #yiv5143963189ygrp-msg p a {font-family:Verdana;}#yiv5143963189 #yiv5143963189ygrp-msg p#yiv5143963189attach-count span {color:#1E66AE;font-weight:700;}#yiv5143963189 #yiv5143963189ygrp-reco #yiv5143963189reco-head {color:#ff7900;font-weight:700;}#yiv5143963189 #yiv5143963189ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5143963189 #yiv5143963189ygrp-sponsor #yiv5143963189ov li a {font-size:130%;text-decoration:none;}#yiv5143963189 #yiv5143963189ygrp-sponsor #yiv5143963189ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5143963189 #yiv5143963189ygrp-sponsor #yiv5143963189ov ul {margin:0;padding:0 0 0 8px;}#yiv5143963189 #yiv5143963189ygrp-text {font-family:Georgia;}#yiv5143963189 #yiv5143963189ygrp-text p {margin:0 0 1em 0;}#yiv5143963189 #yiv5143963189ygrp-text tt {font-size:120%;}#yiv5143963189 #yiv5143963189ygrp-vital ul li:last-child {border-right:none !important;}#yiv5143963189  

1562721597736blob.jpg (90K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Runtime error

fahmi syaifullah
 hallo Master HK.
Baru sadar Pak, payah dah,, kagak nyadar, hehehemakasih pak HK.



    Pada Rabu, 10 Juli 2019 09.28.24 WIB, hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> 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 [hidden email] [belajar-excel]<[hidden email]> 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  

1562721597736blob.jpg (90K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Runtime error

hendrik karnadi
 Hai Fahmi,Memang banyak sekali kemungkinan terjadinya Error dalam penulisan VBA.Mengenai error lainnya, ada beberapa contoh di buku VBA yang saya tulis.
Salam,HK

    Pada Rabu, 10 Juli 2019 15.55.12 GMT+7, Fahmi Syaifullah [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    

 hallo Master HK.
Baru sadar Pak, payah dah,, kagak nyadar, hehehemakasih pak HK.



    Pada Rabu, 10 Juli 2019 09.28.24 WIB, hendrik karnadi [hidden email] [belajar-excel] <[hidden email]> 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 [hidden email] [belajar-excel]<[hidden email]> 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

   
       

1562721597736blob.jpg (90K) Download Attachment