Terimakasih para Master
Cara ini Sub TRACE_HEAT()Worksheets("DATA").Range("E2").Value =
Evaluate("=IFERROR(VLOOKUP(D2,MAIN!$B$3:$L$5,2,FALSE),"""")")End Sub
berhasil namun harus masukkan formula per satu2, apakah bisa bila rangenya
banyak misal yang saya beri warna kuning agar seperti range
(E2) menjadi E2 sd E20000 dan $B$3:$L$5 menjadi $B$3 sd $L$20000
Maaf & Terimakasih
Pada Rabu, 11 November 2015 17:27, "Hendrik Karnadi
hendrikkarn...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:
Coba ganti:Formula......denganValue = Evaluate ("formulanya")Formualanya
tidak perlu diberi tanda =(sama dengan) lagi.
Salam, HK
Sent from Samsung Mobile
-------- Original message --------From: "HAIRUL ALAM ha_m...@yahoo.co.id
[belajar-excel]" Date:11/11/2015 4:11 PM (GMT+07:00) To:
belajar-excel@yahoogroups.com Subject: [belajar-excel] code Macro tanpa
memunculkan formula pada worksheet
Assalamualaikum
Yth. Para Master
Maaf Saya ingin bertanya, saya mempunyai masalah tentang code VBA, yang saya
ingin agar formula tidak muncul pada cell worksheet misalkan code VBA sebagai
berikut :Sub NO_HEAT()Worksheets("DATA").Range("E2", "E20000").Formula =
"=IFERROR(VLOOKUP(D2,PIPE!$B$3:$L$20000,2,FALSE),"""")"End Sub
bagaimana codenya agar yang dimunculkan pada worksheet adalah hasil dari
perhitungan sesuai code VBA diatas dan tidak memunculkan formula pada cell
worksheet
Terimakasih Banyak
MaafHairul Alam
Wassalamualaikum #yiv4131011084 #yiv4131011084 -- #yiv4131011084ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv4131011084 #yiv4131011084ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv4131011084 #yiv4131011084ygrp-mkp #yiv4131011084hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4131011084 #yiv4131011084ygrp-mkp #yiv4131011084ads
{margin-bottom:10px;}#yiv4131011084 #yiv4131011084ygrp-mkp .yiv4131011084ad
{padding:0 0;}#yiv4131011084 #yiv4131011084ygrp-mkp .yiv4131011084ad p
{margin:0;}#yiv4131011084 #yiv4131011084ygrp-mkp .yiv4131011084ad a
{color:#0000ff;text-decoration:none;}#yiv4131011084 #yiv4131011084ygrp-sponsor
#yiv4131011084ygrp-lc {font-family:Arial;}#yiv4131011084
#yiv4131011084ygrp-sponsor #yiv4131011084ygrp-lc #yiv4131011084hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4131011084
#yiv4131011084ygrp-sponsor #yiv4131011084ygrp-lc .yiv4131011084ad
{margin-bottom:10px;padding:0 0;}#yiv4131011084 #yiv4131011084actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4131011084
#yiv4131011084activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4131011084
#yiv4131011084activity span {font-weight:700;}#yiv4131011084
#yiv4131011084activity span:first-child
{text-transform:uppercase;}#yiv4131011084 #yiv4131011084activity span a
{color:#5085b6;text-decoration:none;}#yiv4131011084 #yiv4131011084activity span
span {color:#ff7900;}#yiv4131011084 #yiv4131011084activity span
.yiv4131011084underline {text-decoration:underline;}#yiv4131011084
.yiv4131011084attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4131011084 .yiv4131011084attach div a
{text-decoration:none;}#yiv4131011084 .yiv4131011084attach img
{border:none;padding-right:5px;}#yiv4131011084 .yiv4131011084attach label
{display:block;margin-bottom:5px;}#yiv4131011084 .yiv4131011084attach label a
{text-decoration:none;}#yiv4131011084 blockquote {margin:0 0 0
4px;}#yiv4131011084 .yiv4131011084bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4131011084
.yiv4131011084bold a {text-decoration:none;}#yiv4131011084 dd.yiv4131011084last
p a {font-family:Verdana;font-weight:700;}#yiv4131011084 dd.yiv4131011084last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4131011084
dd.yiv4131011084last p span.yiv4131011084yshortcuts
{margin-right:0;}#yiv4131011084 div.yiv4131011084attach-table div div a
{text-decoration:none;}#yiv4131011084 div.yiv4131011084attach-table
{width:400px;}#yiv4131011084 div.yiv4131011084file-title a, #yiv4131011084
div.yiv4131011084file-title a:active, #yiv4131011084
div.yiv4131011084file-title a:hover, #yiv4131011084 div.yiv4131011084file-title
a:visited {text-decoration:none;}#yiv4131011084 div.yiv4131011084photo-title a,
#yiv4131011084 div.yiv4131011084photo-title a:active, #yiv4131011084
div.yiv4131011084photo-title a:hover, #yiv4131011084
div.yiv4131011084photo-title a:visited {text-decoration:none;}#yiv4131011084
div#yiv4131011084ygrp-mlmsg #yiv4131011084ygrp-msg p a
span.yiv4131011084yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4131011084
.yiv4131011084green {color:#628c2a;}#yiv4131011084 .yiv4131011084MsoNormal
{margin:0 0 0 0;}#yiv4131011084 o {font-size:0;}#yiv4131011084
#yiv4131011084photos div {float:left;width:72px;}#yiv4131011084
#yiv4131011084photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4131011084
#yiv4131011084photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4131011084
#yiv4131011084reco-category {font-size:77%;}#yiv4131011084
#yiv4131011084reco-desc {font-size:77%;}#yiv4131011084 .yiv4131011084replbq
{margin:4px;}#yiv4131011084 #yiv4131011084ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4131011084 #yiv4131011084ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4131011084
#yiv4131011084ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4131011084
#yiv4131011084ygrp-mlmsg select, #yiv4131011084 input, #yiv4131011084 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4131011084
#yiv4131011084ygrp-mlmsg pre, #yiv4131011084 code {font:115%
monospace;}#yiv4131011084 #yiv4131011084ygrp-mlmsg *
{line-height:1.22em;}#yiv4131011084 #yiv4131011084ygrp-mlmsg #yiv4131011084logo
{padding-bottom:10px;}#yiv4131011084 #yiv4131011084ygrp-msg p a
{font-family:Verdana;}#yiv4131011084 #yiv4131011084ygrp-msg
p#yiv4131011084attach-count span {color:#1E66AE;font-weight:700;}#yiv4131011084
#yiv4131011084ygrp-reco #yiv4131011084reco-head
{color:#ff7900;font-weight:700;}#yiv4131011084 #yiv4131011084ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4131011084 #yiv4131011084ygrp-sponsor
#yiv4131011084ov li a {font-size:130%;text-decoration:none;}#yiv4131011084
#yiv4131011084ygrp-sponsor #yiv4131011084ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4131011084
#yiv4131011084ygrp-sponsor #yiv4131011084ov ul {margin:0;padding:0 0 0
8px;}#yiv4131011084 #yiv4131011084ygrp-text
{font-family:Georgia;}#yiv4131011084 #yiv4131011084ygrp-text p {margin:0 0 1em
0;}#yiv4131011084 #yiv4131011084ygrp-text tt {font-size:120%;}#yiv4131011084
#yiv4131011084ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4131011084
