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
#yiv9228421993 #yiv9228421993 -- #yiv9228421993ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9228421993
#yiv9228421993ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9228421993
#yiv9228421993ygrp-mkp #yiv9228421993hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9228421993 #yiv9228421993ygrp-mkp #yiv9228421993ads
{margin-bottom:10px;}#yiv9228421993 #yiv9228421993ygrp-mkp .yiv9228421993ad
{padding:0 0;}#yiv9228421993 #yiv9228421993ygrp-mkp .yiv9228421993ad p
{margin:0;}#yiv9228421993 #yiv9228421993ygrp-mkp .yiv9228421993ad a
{color:#0000ff;text-decoration:none;}#yiv9228421993 #yiv9228421993ygrp-sponsor
#yiv9228421993ygrp-lc {font-family:Arial;}#yiv9228421993
#yiv9228421993ygrp-sponsor #yiv9228421993ygrp-lc #yiv9228421993hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9228421993
#yiv9228421993ygrp-sponsor #yiv9228421993ygrp-lc .yiv9228421993ad
{margin-bottom:10px;padding:0 0;}#yiv9228421993 #yiv9228421993actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9228421993
#yiv9228421993activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9228421993
#yiv9228421993activity span {font-weight:700;}#yiv9228421993
#yiv9228421993activity span:first-child
{text-transform:uppercase;}#yiv9228421993 #yiv9228421993activity span a
{color:#5085b6;text-decoration:none;}#yiv9228421993 #yiv9228421993activity span
span {color:#ff7900;}#yiv9228421993 #yiv9228421993activity span
.yiv9228421993underline {text-decoration:underline;}#yiv9228421993
.yiv9228421993attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9228421993 .yiv9228421993attach div a
{text-decoration:none;}#yiv9228421993 .yiv9228421993attach img
{border:none;padding-right:5px;}#yiv9228421993 .yiv9228421993attach label
{display:block;margin-bottom:5px;}#yiv9228421993 .yiv9228421993attach label a
{text-decoration:none;}#yiv9228421993 blockquote {margin:0 0 0
4px;}#yiv9228421993 .yiv9228421993bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9228421993
.yiv9228421993bold a {text-decoration:none;}#yiv9228421993 dd.yiv9228421993last
p a {font-family:Verdana;font-weight:700;}#yiv9228421993 dd.yiv9228421993last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9228421993
dd.yiv9228421993last p span.yiv9228421993yshortcuts
{margin-right:0;}#yiv9228421993 div.yiv9228421993attach-table div div a
{text-decoration:none;}#yiv9228421993 div.yiv9228421993attach-table
{width:400px;}#yiv9228421993 div.yiv9228421993file-title a, #yiv9228421993
div.yiv9228421993file-title a:active, #yiv9228421993
div.yiv9228421993file-title a:hover, #yiv9228421993 div.yiv9228421993file-title
a:visited {text-decoration:none;}#yiv9228421993 div.yiv9228421993photo-title a,
#yiv9228421993 div.yiv9228421993photo-title a:active, #yiv9228421993
div.yiv9228421993photo-title a:hover, #yiv9228421993
div.yiv9228421993photo-title a:visited {text-decoration:none;}#yiv9228421993
div#yiv9228421993ygrp-mlmsg #yiv9228421993ygrp-msg p a
span.yiv9228421993yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9228421993
.yiv9228421993green {color:#628c2a;}#yiv9228421993 .yiv9228421993MsoNormal
{margin:0 0 0 0;}#yiv9228421993 o {font-size:0;}#yiv9228421993
#yiv9228421993photos div {float:left;width:72px;}#yiv9228421993
#yiv9228421993photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9228421993
#yiv9228421993photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9228421993
#yiv9228421993reco-category {font-size:77%;}#yiv9228421993
#yiv9228421993reco-desc {font-size:77%;}#yiv9228421993 .yiv9228421993replbq
{margin:4px;}#yiv9228421993 #yiv9228421993ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9228421993 #yiv9228421993ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9228421993
#yiv9228421993ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9228421993
#yiv9228421993ygrp-mlmsg select, #yiv9228421993 input, #yiv9228421993 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9228421993
#yiv9228421993ygrp-mlmsg pre, #yiv9228421993 code {font:115%
monospace;}#yiv9228421993 #yiv9228421993ygrp-mlmsg *
{line-height:1.22em;}#yiv9228421993 #yiv9228421993ygrp-mlmsg #yiv9228421993logo
{padding-bottom:10px;}#yiv9228421993 #yiv9228421993ygrp-msg p a
{font-family:Verdana;}#yiv9228421993 #yiv9228421993ygrp-msg
p#yiv9228421993attach-count span {color:#1E66AE;font-weight:700;}#yiv9228421993
#yiv9228421993ygrp-reco #yiv9228421993reco-head
{color:#ff7900;font-weight:700;}#yiv9228421993 #yiv9228421993ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9228421993 #yiv9228421993ygrp-sponsor
#yiv9228421993ov li a {font-size:130%;text-decoration:none;}#yiv9228421993
#yiv9228421993ygrp-sponsor #yiv9228421993ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9228421993
#yiv9228421993ygrp-sponsor #yiv9228421993ov ul {margin:0;padding:0 0 0
8px;}#yiv9228421993 #yiv9228421993ygrp-text
{font-family:Georgia;}#yiv9228421993 #yiv9228421993ygrp-text p {margin:0 0 1em
0;}#yiv9228421993 #yiv9228421993ygrp-text tt {font-size:120%;}#yiv9228421993
#yiv9228421993ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9228421993
