Terima kasih Pak Suyono atas masukannya. Maaf saya lupa melampirkan filenya(file .rar nya harus diextract dulu ke suatu folder, mis:D:\). Pertanyaan saya khusus untuk Macro pada file Macro_Query From Stock_PL,Jika quantity pada file Stok_PL Sheet Stok Item G, yang tidak ada Saldo Awal maupun transaksinya. saya isi dengan angka (mis. angka 1) maka macronya bisa dijalankan.Jika dibiarkan NULL maka macronya akan Error. Sebagai pembanding saya lampirkan juga file yang bernama WKS_Query From Stock_PL yaitu fie yang langsung dilink ke Worksheet melalui Get External Data. Mudah2an penjelasan di atas dapat menjelaskan pertanyaan yang saya tanyakan sebelumnya. Terima kasih. Salam,HK
From: "SUYONO [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Monday, 26 October 2015, 14:34
Subject: RE: [belajar-excel] Menangkap/mengalihkan error
Coba seperti ini Pak HK, semoga sesuai keinginan. Public Function
get_Average(Stock_awal As Double, nilai_beli AsDouble, stok_awal As Double,
qty_pembelian As Double) As Double On Error GoTo Err get_Average = (Stock_awal
+ nilai_beli) / stok_awal +qty_pembelian Exit Function Err: get_Average = 0 End
Function From:[email protected]
[mailto:[email protected]]
Sent: Monday, October 26, 2015 2:16 PM
To: [email protected]
Subject: [belajar-excel] Menangkap/mengalihkan error Dear Be-Excelers,
Saya sedang mencoba membuat perhitungan harga pokok denganmacro SQL).
FORMULA ntuk menghitung harga pokok dengan sistim averageadalah sbb ÷ (Nilai
Stok Awal + nilai pembelian)/qty stok awal + qtypembelian). Permasalahan timbul
ketika hasil penjumlahan pembilang danpenyebut sama2 0(nol)..hasilnya Error.
Pertanyaan saya: Bagaimana penulisannya di macro agar apabila hasilnya
Error,Error tsb diganti dengan 0 (nol) sehingga hppnya = 0 (nol). Terima
kasih. Salam, HK Sent fromSamsung Mobile #yiv6345406161
#yiv6345406161 -- #yiv6345406161ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6345406161
#yiv6345406161ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6345406161
#yiv6345406161ygrp-mkp #yiv6345406161hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6345406161 #yiv6345406161ygrp-mkp #yiv6345406161ads
{margin-bottom:10px;}#yiv6345406161 #yiv6345406161ygrp-mkp .yiv6345406161ad
{padding:0 0;}#yiv6345406161 #yiv6345406161ygrp-mkp .yiv6345406161ad p
{margin:0;}#yiv6345406161 #yiv6345406161ygrp-mkp .yiv6345406161ad a
{color:#0000ff;text-decoration:none;}#yiv6345406161 #yiv6345406161ygrp-sponsor
#yiv6345406161ygrp-lc {font-family:Arial;}#yiv6345406161
#yiv6345406161ygrp-sponsor #yiv6345406161ygrp-lc #yiv6345406161hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6345406161
#yiv6345406161ygrp-sponsor #yiv6345406161ygrp-lc .yiv6345406161ad
{margin-bottom:10px;padding:0 0;}#yiv6345406161 #yiv6345406161actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6345406161
#yiv6345406161activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6345406161
#yiv6345406161activity span {font-weight:700;}#yiv6345406161
#yiv6345406161activity span:first-child
{text-transform:uppercase;}#yiv6345406161 #yiv6345406161activity span a
{color:#5085b6;text-decoration:none;}#yiv6345406161 #yiv6345406161activity span
span {color:#ff7900;}#yiv6345406161 #yiv6345406161activity span
.yiv6345406161underline {text-decoration:underline;}#yiv6345406161
.yiv6345406161attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6345406161 .yiv6345406161attach div a
{text-decoration:none;}#yiv6345406161 .yiv6345406161attach img
{border:none;padding-right:5px;}#yiv6345406161 .yiv6345406161attach label
{display:block;margin-bottom:5px;}#yiv6345406161 .yiv6345406161attach label a
{text-decoration:none;}#yiv6345406161 blockquote {margin:0 0 0
4px;}#yiv6345406161 .yiv6345406161bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6345406161
.yiv6345406161bold a {text-decoration:none;}#yiv6345406161 dd.yiv6345406161last
p a {font-family:Verdana;font-weight:700;}#yiv6345406161 dd.yiv6345406161last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6345406161
dd.yiv6345406161last p span.yiv6345406161yshortcuts
{margin-right:0;}#yiv6345406161 div.yiv6345406161attach-table div div a
{text-decoration:none;}#yiv6345406161 div.yiv6345406161attach-table
{width:400px;}#yiv6345406161 div.yiv6345406161file-title a, #yiv6345406161
div.yiv6345406161file-title a:active, #yiv6345406161
div.yiv6345406161file-title a:hover, #yiv6345406161 div.yiv6345406161file-title
a:visited {text-decoration:none;}#yiv6345406161 div.yiv6345406161photo-title a,
#yiv6345406161 div.yiv6345406161photo-title a:active, #yiv6345406161
div.yiv6345406161photo-title a:hover, #yiv6345406161
div.yiv6345406161photo-title a:visited {text-decoration:none;}#yiv6345406161
div#yiv6345406161ygrp-mlmsg #yiv6345406161ygrp-msg p a
span.yiv6345406161yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6345406161
.yiv6345406161green {color:#628c2a;}#yiv6345406161 .yiv6345406161MsoNormal
{margin:0 0 0 0;}#yiv6345406161 o {font-size:0;}#yiv6345406161
#yiv6345406161photos div {float:left;width:72px;}#yiv6345406161
#yiv6345406161photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6345406161
#yiv6345406161photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6345406161
#yiv6345406161reco-category {font-size:77%;}#yiv6345406161
#yiv6345406161reco-desc {font-size:77%;}#yiv6345406161 .yiv6345406161replbq
{margin:4px;}#yiv6345406161 #yiv6345406161ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6345406161 #yiv6345406161ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6345406161
#yiv6345406161ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6345406161
#yiv6345406161ygrp-mlmsg select, #yiv6345406161 input, #yiv6345406161 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6345406161
#yiv6345406161ygrp-mlmsg pre, #yiv6345406161 code {font:115%
monospace;}#yiv6345406161 #yiv6345406161ygrp-mlmsg *
{line-height:1.22em;}#yiv6345406161 #yiv6345406161ygrp-mlmsg #yiv6345406161logo
{padding-bottom:10px;}#yiv6345406161 #yiv6345406161ygrp-msg p a
{font-family:Verdana;}#yiv6345406161 #yiv6345406161ygrp-msg
p#yiv6345406161attach-count span {color:#1E66AE;font-weight:700;}#yiv6345406161
#yiv6345406161ygrp-reco #yiv6345406161reco-head
{color:#ff7900;font-weight:700;}#yiv6345406161 #yiv6345406161ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6345406161 #yiv6345406161ygrp-sponsor
#yiv6345406161ov li a {font-size:130%;text-decoration:none;}#yiv6345406161
#yiv6345406161ygrp-sponsor #yiv6345406161ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6345406161
#yiv6345406161ygrp-sponsor #yiv6345406161ov ul {margin:0;padding:0 0 0
8px;}#yiv6345406161 #yiv6345406161ygrp-text
{font-family:Georgia;}#yiv6345406161 #yiv6345406161ygrp-text p {margin:0 0 1em
0;}#yiv6345406161 #yiv6345406161ygrp-text tt {font-size:120%;}#yiv6345406161
#yiv6345406161ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6345406161
SQL.rar
Description: Binary data
