[belajar-excel] Digest Number 4812

Milis Belajar Microsoft Excel Group

1 Message

Digest #4812

1a

Re: menampilkan hasil tanpa formula di excel dengan script macro by "HAIRUL ALAM"

Message

1a

Re: menampilkan hasil tanpa formula di excel dengan script macro

Sat Aug 3, 2019 2:33 am (PDT) . Posted by:

"HAIRUL ALAM"

Maaf
Bila bukan vlookup melainkan rumus seperti file terlampir, seperti apa code macro copy pastenya agar rumusnya tidak tampil, dan hanya hasil formulanya saja
Terimakasih
Pada Jumat, 2 Agustus 2019 23.31.56 WIB, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 



Langsung ke TKP aja ya di file terlampir.
Salam,HK
Pada Jumat, 2 Agustus 2019 19.32.08 WIB, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Makasih Mas HK
Maaf, Jika menggunakan code Sheets("b").Range("c4").Value2 = Evaluate("=VLOOKUP(B4,a!B4:D6,2,FALSE)")hanya apa digunakan untuk 1 baris, kalau misalkan barisnya sampai 1000 code copy paste hasilnya seperti apa ya
Terimakasih bayakMaaf, jika saya kurang paham masalah code macro Pada Selasa, 30 Juli 2019 14.04.04 WIB, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Coba ganti codenya spt ini :Sheets("b").Range("c4").Value2 = Evaluate("=VLOOKUP(B4,a!B4:D6,2,FALSE)")

Salam,HK

Pada Selasa, 30 Juli 2019 07.47.34 WIB, HAIRUL ALAM ha_mj76@yahoo..co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

SalamPara Master
mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir

Terimakasih
Assalamualaikum
Hairul Alam #yiv6507900507 -- #yiv6507900507ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6507900507 #yiv6507900507ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6507900507 #yiv6507900507ygrp-mkp #yiv6507900507hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6507900507 #yiv6507900507ygrp-mkp #yiv6507900507ads {margin-bottom:10px;}#yiv6507900507 #yiv6507900507ygrp-mkp .yiv6507900507ad {padding:0 0;}#yiv6507900507 #yiv6507900507ygrp-mkp .yiv6507900507ad p {margin:0;}#yiv6507900507 #yiv6507900507ygrp-mkp .yiv6507900507ad a {color:#0000ff;text-decoration:none;}#yiv6507900507 #yiv6507900507ygrp-sponsor #yiv6507900507ygrp-lc {font-family:Arial;}#yiv6507900507 #yiv6507900507ygrp-sponsor #yiv6507900507ygrp-lc #yiv6507900507hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6507900507 #yiv6507900507ygrp-sponsor #yiv6507900507ygrp-lc .yiv6507900507ad {margin-bottom:10px;padding:0 0;}#yiv6507900507 #yiv6507900507actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6507900507 #yiv6507900507activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6507900507 #yiv6507900507activity span {font-weight:700;}#yiv6507900507 #yiv6507900507activity span:first-child {text-transform:uppercase;}#yiv6507900507 #yiv6507900507activity span a {color:#5085b6;text-decoration:none;}#yiv6507900507 #yiv6507900507activity span span {color:#ff7900;}#yiv6507900507 #yiv6507900507activity span .yiv6507900507underline {text-decoration:underline;}#yiv6507900507 .yiv6507900507attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6507900507 .yiv6507900507attach div a {text-decoration:none;}#yiv6507900507 .yiv6507900507attach img {border:none;padding-right:5px;}#yiv6507900507 .yiv6507900507attach label {display:block;margin-bottom:5px;}#yiv6507900507 .yiv6507900507attach label a {text-decoration:none;}#yiv6507900507 blockquote {margin:0 0 0 4px;}#yiv6507900507 .yiv6507900507bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6507900507 .yiv6507900507bold a {text-decoration:none;}#yiv6507900507 dd.yiv6507900507last p a {font-family:Verdana;font-weight:700;}#yiv6507900507 dd.yiv6507900507last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6507900507 dd.yiv6507900507last p span..yiv6507900507yshortcuts {margin-right:0;}#yiv6507900507 div..yiv6507900507attach-table div div a {text-decoration:none;}#yiv6507900507 div.yiv6507900507attach-table {width:400px;}#yiv6507900507 div.yiv6507900507file-title a, #yiv6507900507 div.yiv6507900507file-title a:active, #yiv6507900507 div.yiv6507900507file-title a:hover, #yiv6507900507 div.yiv6507900507file-title a:visited {text-decoration:none;}#yiv6507900507 div.yiv6507900507photo-title a, #yiv6507900507 div.yiv6507900507photo-title a:active, #yiv6507900507 div.yiv6507900507photo-title a:hover, #yiv6507900507 div.yiv6507900507photo-title a:visited {text-decoration:none;}#yiv6507900507 div#yiv6507900507ygrp-mlmsg #yiv6507900507ygrp-msg p a span.yiv6507900507yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6507900507 .yiv6507900507green {color:#628c2a;}#yiv6507900507 .yiv6507900507MsoNormal {margin:0 0 0 0;}#yiv6507900507 o {font-size:0;}#yiv6507900507 #yiv6507900507photos div {float:left;width:72px;}#yiv6507900507 #yiv6507900507photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv6507900507 #yiv6507900507photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6507900507 #yiv6507900507reco-category {font-size:77%;}#yiv6507900507 #yiv6507900507reco-desc {font-size:77%;}#yiv6507900507 .yiv6507900507replbq {margin:4px;}#yiv6507900507 #yiv6507900507ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6507900507 #yiv6507900507ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6507900507 #yiv6507900507ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6507900507 #yiv6507900507ygrp-mlmsg select, #yiv6507900507 input, #yiv6507900507 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6507900507 #yiv6507900507ygrp-mlmsg pre, #yiv6507900507 code {font:115% monospace;}#yiv6507900507 #yiv6507900507ygrp-mlmsg * {line-height:1.22em;}#yiv6507900507 #yiv6507900507ygrp-mlmsg #yiv6507900507logo {padding-bottom:10px;}#yiv6507900507 #yiv6507900507ygrp-msg p a {font-family:Verdana;}#yiv6507900507 #yiv6507900507ygrp-msg p#yiv6507900507attach-count span {color:#1E66AE;font-weight:700;}#yiv6507900507 #yiv6507900507ygrp-reco #yiv6507900507reco-head {color:#ff7900;font-weight:700;}#yiv6507900507 #yiv6507900507ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6507900507 #yiv6507900507ygrp-sponsor #yiv6507900507ov li a {font-size:130%;text-decoration:none;}#yiv6507900507 #yiv6507900507ygrp-sponsor #yiv6507900507ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6507900507 #yiv6507900507ygrp-sponsor #yiv6507900507ov ul {margin:0;padding:0 0 0 8px;}#yiv6507900507 #yiv6507900507ygrp-text {font-family:Georgia;}#yiv6507900507 #yiv6507900507ygrp-text p {margin:0 0 1em 0;}#yiv6507900507 #yiv6507900507ygrp-text tt {font-size:120%;}#yiv6507900507 #yiv6507900507ygrp-vital ul li:last-child {border-right:none !important;}#yiv6507900507

Reply to sender . Reply to group . Reply via Web Post . All Messages (10) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use