[belajar-excel] Digest Number 4811

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4811

1a

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

1b

Re: menampilkan hasil tanpa formula di excel dengan script macro by "hendrik karnadi" hendrikkarnadi

Messages

1a

Re: menampilkan hasil tanpa formula di excel dengan script macro

Fri Aug 2, 2019 5:31 am (PDT) . Posted by:

"HAIRUL ALAM"

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 #yiv3589765478 #yiv3589765478 -- #yiv3589765478ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3589765478 #yiv3589765478ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3589765478 #yiv3589765478ygrp-mkp #yiv3589765478hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3589765478 #yiv3589765478ygrp-mkp #yiv3589765478ads {margin-bottom:10px;}#yiv3589765478 #yiv3589765478ygrp-mkp .yiv3589765478ad {padding:0 0;}#yiv3589765478 #yiv3589765478ygrp-mkp .yiv3589765478ad p {margin:0;}#yiv3589765478 #yiv3589765478ygrp-mkp .yiv3589765478ad a {color:#0000ff;text-decoration:none;}#yiv3589765478 #yiv3589765478ygrp-sponsor #yiv3589765478ygrp-lc {font-family:Arial;}#yiv3589765478 #yiv3589765478ygrp-sponsor #yiv3589765478ygrp-lc #yiv3589765478hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3589765478 #yiv3589765478ygrp-sponsor #yiv3589765478ygrp-lc .yiv3589765478ad {margin-bottom:10px;padding:0 0;}#yiv3589765478 #yiv3589765478actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3589765478 #yiv3589765478activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3589765478 #yiv3589765478activity span {font-weight:700;}#yiv3589765478 #yiv3589765478activity span:first-child {text-transform:uppercase;}#yiv3589765478 #yiv3589765478activity span a {color:#5085b6;text-decoration:none;}#yiv3589765478 #yiv3589765478activity span span {color:#ff7900;}#yiv3589765478 #yiv3589765478activity span .yiv3589765478underline {text-decoration:underline;}#yiv3589765478 .yiv3589765478attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3589765478 .yiv3589765478attach div a {text-decoration:none;}#yiv3589765478 .yiv3589765478attach img {border:none;padding-right:5px;}#yiv3589765478 .yiv3589765478attach label {display:block;margin-bottom:5px;}#yiv3589765478 .yiv3589765478attach label a {text-decoration:none;}#yiv3589765478 blockquote {margin:0 0 0 4px;}#yiv3589765478 .yiv3589765478bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3589765478 .yiv3589765478bold a {text-decoration:none;}#yiv3589765478 dd.yiv3589765478last p a {font-family:Verdana;font-weight:700;}#yiv3589765478 dd.yiv3589765478last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3589765478 dd.yiv3589765478last p span.yiv3589765478yshortcuts {margin-right:0;}#yiv3589765478 div.yiv3589765478attach-table div div a {text-decoration:none;}#yiv3589765478 div.yiv3589765478attach-table {width:400px;}#yiv3589765478 div.yiv3589765478file-title a, #yiv3589765478 div.yiv3589765478file-title a:active, #yiv3589765478 div.yiv3589765478file-title a:hover, #yiv3589765478 div.yiv3589765478file-title a:visited {text-decoration:none;}#yiv3589765478 div.yiv3589765478photo-title a, #yiv3589765478 div.yiv3589765478photo-title a:active, #yiv3589765478 div.yiv3589765478photo-title a:hover, #yiv3589765478 div.yiv3589765478photo-title a:visited {text-decoration:none;}#yiv3589765478 div#yiv3589765478ygrp-mlmsg #yiv3589765478ygrp-msg p a span.yiv3589765478yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3589765478 .yiv3589765478green {color:#628c2a;}#yiv3589765478 .yiv3589765478MsoNormal {margin:0 0 0 0;}#yiv3589765478 o {font-size:0;}#yiv3589765478 #yiv3589765478photos div {float:left;width:72px;}#yiv3589765478 #yiv3589765478photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3589765478 #yiv3589765478photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3589765478 #yiv3589765478reco-category {font-size:77%;}#yiv3589765478 #yiv3589765478reco-desc {font-size:77%;}#yiv3589765478 ..yiv3589765478replbq {margin:4px;}#yiv3589765478 #yiv3589765478ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3589765478 #yiv3589765478ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3589765478 #yiv3589765478ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3589765478 #yiv3589765478ygrp-mlmsg select, #yiv3589765478 input, #yiv3589765478 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3589765478 #yiv3589765478ygrp-mlmsg pre, #yiv3589765478 code {font:115% monospace;}#yiv3589765478 #yiv3589765478ygrp-mlmsg * {line-height:1.22em;}#yiv3589765478 #yiv3589765478ygrp-mlmsg #yiv3589765478logo {padding-bottom:10px;}#yiv3589765478 #yiv3589765478ygrp-msg p a {font-family:Verdana;}#yiv3589765478 #yiv3589765478ygrp-msg p#yiv3589765478attach-count span {color:#1E66AE;font-weight:700;}#yiv3589765478 #yiv3589765478ygrp-reco #yiv3589765478reco-head {color:#ff7900;font-weight:700;}#yiv3589765478 #yiv3589765478ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3589765478 #yiv3589765478ygrp-sponsor #yiv3589765478ov li a {font-size:130%;text-decoration:none;}#yiv3589765478 #yiv3589765478ygrp-sponsor #yiv3589765478ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3589765478 #yiv3589765478ygrp-sponsor #yiv3589765478ov ul {margin:0;padding:0 0 0 8px;}#yiv3589765478 #yiv3589765478ygrp-text {font-family:Georgia;}#yiv3589765478 #yiv3589765478ygrp-text p {margin:0 0 1em 0;}#yiv3589765478 #yiv3589765478ygrp-text tt {font-size:120%;}#yiv3589765478 #yiv3589765478ygrp-vital ul li:last-child {border-right:none !important;}#yiv3589765478

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

1b

Re: menampilkan hasil tanpa formula di excel dengan script macro

Fri Aug 2, 2019 9:30 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (9) . 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