Terimakasih Mas Riki
Pada Rabu, 11 November 2015 16:33, "'Riki' ricky45chi...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> 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: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] Sent: Wednesday, November 11, 2015 4:11 PM 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 #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