wah fixed, dan ternyata lebih gampang pake formula ya kang toby hehemakasih
banyak master
On Wednesday, January 20, 2016 10:04 PM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
| Hai Bayu,Berikut filenya, warna kuning pake vba,warna biru pake formula
excel.Anda bisa bandingkan mana yg lebih mudah,jika bisa di selesaikan dgn
formula,pakailah formula excel, jika sudah tidak bisa diselesaikan dgn formula
excel, gunakan Vba.TerimaKasih.Sent from Yahoo Mail on Android |
From: Bayu Prasaja [email protected] [belajar-excel]
<[email protected]>;
To: [email protected] <[email protected]>;
Subject: Re: [belajar-excel] SUM Komulatif (VBA)
Sent: Wed, Jan 20, 2016 9:23:25 AM
| iya master, soalnya cell "hasil"-nya dynamic ,terus klo formula pasti
saya rubah lagi ke format .formula atau .R1c1 di vbajadi klo boleh langsung vba
master, atau pake formula tapi dalam bentuk vba di cell.formula atau
cell.formulaR1C1 hehehemaaf klo penjelasannya ngacokurang lebih gitu yang baru
saya pahami hehe
On Wednesday, January 20, 2016 4:18 PM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Wa'alaikumussalam wr wb
Harus dengan VBA ya ?
Wassalamu'alaikum wr wb
Kid
2016-01-20 16:12 GMT+07:00 [email protected] [belajar-excel]
<[email protected]>:
Asslamu'alaikum
sore master,
mau nanya VBA untuk penjumlahan komulatif, yang menggunakan dynamic range, dan
tiap hasil penjumlahan ditampilkan..
kalo pake autofill dsetination mungkin bisa, tapi bukan itu si yang saya
pengen, soalnya harus berderet kalo autofill, kalo boleh pake "for" "next"
hehehe
maaf jika pertanyaan atau pernyataan saya banyak yang salah, soalnya baru
belajar , jadi agak bingung nanya nya juga hehe,
Terima kasih sebelumnya
File contoh terlampir
Wassalamu'alaikum warahmatullohi wabarokatuh
|
#yiv3896351717 #yiv3896351717 -- #yiv3896351717ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3896351717
#yiv3896351717ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3896351717
#yiv3896351717ygrp-mkp #yiv3896351717hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3896351717 #yiv3896351717ygrp-mkp #yiv3896351717ads
{margin-bottom:10px;}#yiv3896351717 #yiv3896351717ygrp-mkp .yiv3896351717ad
{padding:0 0;}#yiv3896351717 #yiv3896351717ygrp-mkp .yiv3896351717ad p
{margin:0;}#yiv3896351717 #yiv3896351717ygrp-mkp .yiv3896351717ad a
{color:#0000ff;text-decoration:none;}#yiv3896351717 #yiv3896351717ygrp-sponsor
#yiv3896351717ygrp-lc {font-family:Arial;}#yiv3896351717
#yiv3896351717ygrp-sponsor #yiv3896351717ygrp-lc #yiv3896351717hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3896351717
#yiv3896351717ygrp-sponsor #yiv3896351717ygrp-lc .yiv3896351717ad
{margin-bottom:10px;padding:0 0;}#yiv3896351717 #yiv3896351717actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3896351717
#yiv3896351717activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3896351717
#yiv3896351717activity span {font-weight:700;}#yiv3896351717
#yiv3896351717activity span:first-child
{text-transform:uppercase;}#yiv3896351717 #yiv3896351717activity span a
{color:#5085b6;text-decoration:none;}#yiv3896351717 #yiv3896351717activity span
span {color:#ff7900;}#yiv3896351717 #yiv3896351717activity span
.yiv3896351717underline {text-decoration:underline;}#yiv3896351717
.yiv3896351717attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3896351717 .yiv3896351717attach div a
{text-decoration:none;}#yiv3896351717 .yiv3896351717attach img
{border:none;padding-right:5px;}#yiv3896351717 .yiv3896351717attach label
{display:block;margin-bottom:5px;}#yiv3896351717 .yiv3896351717attach label a
{text-decoration:none;}#yiv3896351717 blockquote {margin:0 0 0
4px;}#yiv3896351717 .yiv3896351717bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3896351717
.yiv3896351717bold a {text-decoration:none;}#yiv3896351717 dd.yiv3896351717last
p a {font-family:Verdana;font-weight:700;}#yiv3896351717 dd.yiv3896351717last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3896351717
dd.yiv3896351717last p span.yiv3896351717yshortcuts
{margin-right:0;}#yiv3896351717 div.yiv3896351717attach-table div div a
{text-decoration:none;}#yiv3896351717 div.yiv3896351717attach-table
{width:400px;}#yiv3896351717 div.yiv3896351717file-title a, #yiv3896351717
div.yiv3896351717file-title a:active, #yiv3896351717
div.yiv3896351717file-title a:hover, #yiv3896351717 div.yiv3896351717file-title
a:visited {text-decoration:none;}#yiv3896351717 div.yiv3896351717photo-title a,
#yiv3896351717 div.yiv3896351717photo-title a:active, #yiv3896351717
div.yiv3896351717photo-title a:hover, #yiv3896351717
div.yiv3896351717photo-title a:visited {text-decoration:none;}#yiv3896351717
div#yiv3896351717ygrp-mlmsg #yiv3896351717ygrp-msg p a
span.yiv3896351717yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3896351717
.yiv3896351717green {color:#628c2a;}#yiv3896351717 .yiv3896351717MsoNormal
{margin:0 0 0 0;}#yiv3896351717 o {font-size:0;}#yiv3896351717
#yiv3896351717photos div {float:left;width:72px;}#yiv3896351717
#yiv3896351717photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3896351717
#yiv3896351717photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3896351717
#yiv3896351717reco-category {font-size:77%;}#yiv3896351717
#yiv3896351717reco-desc {font-size:77%;}#yiv3896351717 .yiv3896351717replbq
{margin:4px;}#yiv3896351717 #yiv3896351717ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3896351717 #yiv3896351717ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3896351717
#yiv3896351717ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3896351717
#yiv3896351717ygrp-mlmsg select, #yiv3896351717 input, #yiv3896351717 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3896351717
#yiv3896351717ygrp-mlmsg pre, #yiv3896351717 code {font:115%
monospace;}#yiv3896351717 #yiv3896351717ygrp-mlmsg *
{line-height:1.22em;}#yiv3896351717 #yiv3896351717ygrp-mlmsg #yiv3896351717logo
{padding-bottom:10px;}#yiv3896351717 #yiv3896351717ygrp-msg p a
{font-family:Verdana;}#yiv3896351717 #yiv3896351717ygrp-msg
p#yiv3896351717attach-count span {color:#1E66AE;font-weight:700;}#yiv3896351717
#yiv3896351717ygrp-reco #yiv3896351717reco-head
{color:#ff7900;font-weight:700;}#yiv3896351717 #yiv3896351717ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3896351717 #yiv3896351717ygrp-sponsor
#yiv3896351717ov li a {font-size:130%;text-decoration:none;}#yiv3896351717
#yiv3896351717ygrp-sponsor #yiv3896351717ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3896351717
#yiv3896351717ygrp-sponsor #yiv3896351717ov ul {margin:0;padding:0 0 0
8px;}#yiv3896351717 #yiv3896351717ygrp-text
{font-family:Georgia;}#yiv3896351717 #yiv3896351717ygrp-text p {margin:0 0 1em
0;}#yiv3896351717 #yiv3896351717ygrp-text tt {font-size:120%;}#yiv3896351717
#yiv3896351717ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3896351717
