Terimakasih banyak informasinya
Master
Salam
Pada Rabu, 11 November 2015 19:08, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
| Dear Hairul,Pada dasarnya semua bisa di lakuakan oleh VBA , namun alangkah
bijak jika formula yg sudah tercover oleh Excel biarlah dilakukan oleh fungsi2
excel itu sendiri, VBA, hanya mengtrigger apa yg kita inginkan saja.
Coba bisa di bayangka jika VBA harus bekerja menghitung setiap formula yg anda
buat(sampai 19998 cell)...
Ya itu hanya masukan saja sih..TerimaKasih.
Sent from Yahoo Mail on Android |
From: HAIRUL ALAM [email protected] [belajar-excel]
<[email protected]>;
To: <[email protected]>;
Subject: Bls: [belajar-excel] code Macro tanpa memunculkan formula pada
worksheet
Sent: Wed, Nov 11, 2015 10:44:07 AM
| 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
[email protected] [belajar-excel]" <[email protected]>
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 [email protected]
[belajar-excel]" Date:11/11/2015 4:11 PM (GMT+07:00) 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
|
#yiv4021240757 #yiv4021240757 -- #yiv4021240757ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4021240757
#yiv4021240757ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4021240757
#yiv4021240757ygrp-mkp #yiv4021240757hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4021240757 #yiv4021240757ygrp-mkp #yiv4021240757ads
{margin-bottom:10px;}#yiv4021240757 #yiv4021240757ygrp-mkp .yiv4021240757ad
{padding:0 0;}#yiv4021240757 #yiv4021240757ygrp-mkp .yiv4021240757ad p
{margin:0;}#yiv4021240757 #yiv4021240757ygrp-mkp .yiv4021240757ad a
{color:#0000ff;text-decoration:none;}#yiv4021240757 #yiv4021240757ygrp-sponsor
#yiv4021240757ygrp-lc {font-family:Arial;}#yiv4021240757
#yiv4021240757ygrp-sponsor #yiv4021240757ygrp-lc #yiv4021240757hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4021240757
#yiv4021240757ygrp-sponsor #yiv4021240757ygrp-lc .yiv4021240757ad
{margin-bottom:10px;padding:0 0;}#yiv4021240757 #yiv4021240757actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4021240757
#yiv4021240757activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4021240757
#yiv4021240757activity span {font-weight:700;}#yiv4021240757
#yiv4021240757activity span:first-child
{text-transform:uppercase;}#yiv4021240757 #yiv4021240757activity span a
{color:#5085b6;text-decoration:none;}#yiv4021240757 #yiv4021240757activity span
span {color:#ff7900;}#yiv4021240757 #yiv4021240757activity span
.yiv4021240757underline {text-decoration:underline;}#yiv4021240757
.yiv4021240757attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4021240757 .yiv4021240757attach div a
{text-decoration:none;}#yiv4021240757 .yiv4021240757attach img
{border:none;padding-right:5px;}#yiv4021240757 .yiv4021240757attach label
{display:block;margin-bottom:5px;}#yiv4021240757 .yiv4021240757attach label a
{text-decoration:none;}#yiv4021240757 blockquote {margin:0 0 0
4px;}#yiv4021240757 .yiv4021240757bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4021240757
.yiv4021240757bold a {text-decoration:none;}#yiv4021240757 dd.yiv4021240757last
p a {font-family:Verdana;font-weight:700;}#yiv4021240757 dd.yiv4021240757last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4021240757
dd.yiv4021240757last p span.yiv4021240757yshortcuts
{margin-right:0;}#yiv4021240757 div.yiv4021240757attach-table div div a
{text-decoration:none;}#yiv4021240757 div.yiv4021240757attach-table
{width:400px;}#yiv4021240757 div.yiv4021240757file-title a, #yiv4021240757
div.yiv4021240757file-title a:active, #yiv4021240757
div.yiv4021240757file-title a:hover, #yiv4021240757 div.yiv4021240757file-title
a:visited {text-decoration:none;}#yiv4021240757 div.yiv4021240757photo-title a,
#yiv4021240757 div.yiv4021240757photo-title a:active, #yiv4021240757
div.yiv4021240757photo-title a:hover, #yiv4021240757
div.yiv4021240757photo-title a:visited {text-decoration:none;}#yiv4021240757
div#yiv4021240757ygrp-mlmsg #yiv4021240757ygrp-msg p a
span.yiv4021240757yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4021240757
.yiv4021240757green {color:#628c2a;}#yiv4021240757 .yiv4021240757MsoNormal
{margin:0 0 0 0;}#yiv4021240757 o {font-size:0;}#yiv4021240757
#yiv4021240757photos div {float:left;width:72px;}#yiv4021240757
#yiv4021240757photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4021240757
#yiv4021240757photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4021240757
#yiv4021240757reco-category {font-size:77%;}#yiv4021240757
#yiv4021240757reco-desc {font-size:77%;}#yiv4021240757 .yiv4021240757replbq
{margin:4px;}#yiv4021240757 #yiv4021240757ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4021240757 #yiv4021240757ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4021240757
#yiv4021240757ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4021240757
#yiv4021240757ygrp-mlmsg select, #yiv4021240757 input, #yiv4021240757 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4021240757
#yiv4021240757ygrp-mlmsg pre, #yiv4021240757 code {font:115%
monospace;}#yiv4021240757 #yiv4021240757ygrp-mlmsg *
{line-height:1.22em;}#yiv4021240757 #yiv4021240757ygrp-mlmsg #yiv4021240757logo
{padding-bottom:10px;}#yiv4021240757 #yiv4021240757ygrp-msg p a
{font-family:Verdana;}#yiv4021240757 #yiv4021240757ygrp-msg
p#yiv4021240757attach-count span {color:#1E66AE;font-weight:700;}#yiv4021240757
#yiv4021240757ygrp-reco #yiv4021240757reco-head
{color:#ff7900;font-weight:700;}#yiv4021240757 #yiv4021240757ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4021240757 #yiv4021240757ygrp-sponsor
#yiv4021240757ov li a {font-size:130%;text-decoration:none;}#yiv4021240757
#yiv4021240757ygrp-sponsor #yiv4021240757ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4021240757
#yiv4021240757ygrp-sponsor #yiv4021240757ov ul {margin:0;padding:0 0 0
8px;}#yiv4021240757 #yiv4021240757ygrp-text
{font-family:Georgia;}#yiv4021240757 #yiv4021240757ygrp-text p {margin:0 0 1em
0;}#yiv4021240757 #yiv4021240757ygrp-text tt {font-size:120%;}#yiv4021240757
#yiv4021240757ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4021240757
