Terimakasih Mas Riki
Pada Rabu, 11 November 2015 16:33, "'Riki' [email protected]
[belajar-excel]" <[email protected]> menulis:
Wa’alaikum slm Pak Haerul Setelah kode macro tersebut tinggal
ditambah“Selection = Selection.Value”ContohSub
NO_HEAT()Worksheets("DATA").Range("E2", "E20000").Formula =
"=IFERROR(VLOOKUP(D2,PIPE!$B$3:$L$20000,2,FALSE),"""")"Selection =
Selection.ValueEnd Sub Semoga membantuTrimsRikiFrom:
[email protected] [mailto:[email protected]]
Sent: Wednesday, November 11, 2015 4:11 PM
To: [email protected]
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 #yiv7000351193
#yiv7000351193 -- #yiv7000351193ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7000351193
#yiv7000351193ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7000351193
#yiv7000351193ygrp-mkp #yiv7000351193hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7000351193 #yiv7000351193ygrp-mkp #yiv7000351193ads
{margin-bottom:10px;}#yiv7000351193 #yiv7000351193ygrp-mkp .yiv7000351193ad
{padding:0 0;}#yiv7000351193 #yiv7000351193ygrp-mkp .yiv7000351193ad p
{margin:0;}#yiv7000351193 #yiv7000351193ygrp-mkp .yiv7000351193ad a
{color:#0000ff;text-decoration:none;}#yiv7000351193 #yiv7000351193ygrp-sponsor
#yiv7000351193ygrp-lc {font-family:Arial;}#yiv7000351193
#yiv7000351193ygrp-sponsor #yiv7000351193ygrp-lc #yiv7000351193hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7000351193
#yiv7000351193ygrp-sponsor #yiv7000351193ygrp-lc .yiv7000351193ad
{margin-bottom:10px;padding:0 0;}#yiv7000351193 #yiv7000351193actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7000351193
#yiv7000351193activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7000351193
#yiv7000351193activity span {font-weight:700;}#yiv7000351193
#yiv7000351193activity span:first-child
{text-transform:uppercase;}#yiv7000351193 #yiv7000351193activity span a
{color:#5085b6;text-decoration:none;}#yiv7000351193 #yiv7000351193activity span
span {color:#ff7900;}#yiv7000351193 #yiv7000351193activity span
.yiv7000351193underline {text-decoration:underline;}#yiv7000351193
.yiv7000351193attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7000351193 .yiv7000351193attach div a
{text-decoration:none;}#yiv7000351193 .yiv7000351193attach img
{border:none;padding-right:5px;}#yiv7000351193 .yiv7000351193attach label
{display:block;margin-bottom:5px;}#yiv7000351193 .yiv7000351193attach label a
{text-decoration:none;}#yiv7000351193 blockquote {margin:0 0 0
4px;}#yiv7000351193 .yiv7000351193bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7000351193
.yiv7000351193bold a {text-decoration:none;}#yiv7000351193 dd.yiv7000351193last
p a {font-family:Verdana;font-weight:700;}#yiv7000351193 dd.yiv7000351193last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7000351193
dd.yiv7000351193last p span.yiv7000351193yshortcuts
{margin-right:0;}#yiv7000351193 div.yiv7000351193attach-table div div a
{text-decoration:none;}#yiv7000351193 div.yiv7000351193attach-table
{width:400px;}#yiv7000351193 div.yiv7000351193file-title a, #yiv7000351193
div.yiv7000351193file-title a:active, #yiv7000351193
div.yiv7000351193file-title a:hover, #yiv7000351193 div.yiv7000351193file-title
a:visited {text-decoration:none;}#yiv7000351193 div.yiv7000351193photo-title a,
#yiv7000351193 div.yiv7000351193photo-title a:active, #yiv7000351193
div.yiv7000351193photo-title a:hover, #yiv7000351193
div.yiv7000351193photo-title a:visited {text-decoration:none;}#yiv7000351193
div#yiv7000351193ygrp-mlmsg #yiv7000351193ygrp-msg p a
span.yiv7000351193yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7000351193
.yiv7000351193green {color:#628c2a;}#yiv7000351193 .yiv7000351193MsoNormal
{margin:0 0 0 0;}#yiv7000351193 o {font-size:0;}#yiv7000351193
#yiv7000351193photos div {float:left;width:72px;}#yiv7000351193
#yiv7000351193photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7000351193
#yiv7000351193photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7000351193
#yiv7000351193reco-category {font-size:77%;}#yiv7000351193
#yiv7000351193reco-desc {font-size:77%;}#yiv7000351193 .yiv7000351193replbq
{margin:4px;}#yiv7000351193 #yiv7000351193ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7000351193 #yiv7000351193ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7000351193
#yiv7000351193ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7000351193
#yiv7000351193ygrp-mlmsg select, #yiv7000351193 input, #yiv7000351193 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7000351193
#yiv7000351193ygrp-mlmsg pre, #yiv7000351193 code {font:115%
monospace;}#yiv7000351193 #yiv7000351193ygrp-mlmsg *
{line-height:1.22em;}#yiv7000351193 #yiv7000351193ygrp-mlmsg #yiv7000351193logo
{padding-bottom:10px;}#yiv7000351193 #yiv7000351193ygrp-msg p a
{font-family:Verdana;}#yiv7000351193 #yiv7000351193ygrp-msg
p#yiv7000351193attach-count span {color:#1E66AE;font-weight:700;}#yiv7000351193
#yiv7000351193ygrp-reco #yiv7000351193reco-head
{color:#ff7900;font-weight:700;}#yiv7000351193 #yiv7000351193ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7000351193 #yiv7000351193ygrp-sponsor
#yiv7000351193ov li a {font-size:130%;text-decoration:none;}#yiv7000351193
#yiv7000351193ygrp-sponsor #yiv7000351193ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7000351193
#yiv7000351193ygrp-sponsor #yiv7000351193ov ul {margin:0;padding:0 0 0
8px;}#yiv7000351193 #yiv7000351193ygrp-text
{font-family:Georgia;}#yiv7000351193 #yiv7000351193ygrp-text p {margin:0 0 1em
0;}#yiv7000351193 #yiv7000351193ygrp-text tt {font-size:120%;}#yiv7000351193
#yiv7000351193ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7000351193
