ternyata pake formula master jadinya seperti di attachment (dari Mr toby ) hahaha, terlalu jauh mungkin saya mikirnya ya kangtapi saya rubah formulanya ke R1c1 di vba nya makasih banyak master
On Wednesday, January 20, 2016 4:27 PM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
Dinamisnya seperti apa ?
On Wed, Jan 20, 2016 at 4:23 PM, Bayu Prasaja [email protected]
[belajar-excel] <[email protected]> wrote:
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
#yiv6808082496 #yiv6808082496 -- #yiv6808082496ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6808082496
#yiv6808082496ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6808082496
#yiv6808082496ygrp-mkp #yiv6808082496hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6808082496 #yiv6808082496ygrp-mkp #yiv6808082496ads
{margin-bottom:10px;}#yiv6808082496 #yiv6808082496ygrp-mkp .yiv6808082496ad
{padding:0 0;}#yiv6808082496 #yiv6808082496ygrp-mkp .yiv6808082496ad p
{margin:0;}#yiv6808082496 #yiv6808082496ygrp-mkp .yiv6808082496ad a
{color:#0000ff;text-decoration:none;}#yiv6808082496 #yiv6808082496ygrp-sponsor
#yiv6808082496ygrp-lc {font-family:Arial;}#yiv6808082496
#yiv6808082496ygrp-sponsor #yiv6808082496ygrp-lc #yiv6808082496hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6808082496
#yiv6808082496ygrp-sponsor #yiv6808082496ygrp-lc .yiv6808082496ad
{margin-bottom:10px;padding:0 0;}#yiv6808082496 #yiv6808082496actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6808082496
#yiv6808082496activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6808082496
#yiv6808082496activity span {font-weight:700;}#yiv6808082496
#yiv6808082496activity span:first-child
{text-transform:uppercase;}#yiv6808082496 #yiv6808082496activity span a
{color:#5085b6;text-decoration:none;}#yiv6808082496 #yiv6808082496activity span
span {color:#ff7900;}#yiv6808082496 #yiv6808082496activity span
.yiv6808082496underline {text-decoration:underline;}#yiv6808082496
.yiv6808082496attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6808082496 .yiv6808082496attach div a
{text-decoration:none;}#yiv6808082496 .yiv6808082496attach img
{border:none;padding-right:5px;}#yiv6808082496 .yiv6808082496attach label
{display:block;margin-bottom:5px;}#yiv6808082496 .yiv6808082496attach label a
{text-decoration:none;}#yiv6808082496 blockquote {margin:0 0 0
4px;}#yiv6808082496 .yiv6808082496bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6808082496
.yiv6808082496bold a {text-decoration:none;}#yiv6808082496 dd.yiv6808082496last
p a {font-family:Verdana;font-weight:700;}#yiv6808082496 dd.yiv6808082496last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6808082496
dd.yiv6808082496last p span.yiv6808082496yshortcuts
{margin-right:0;}#yiv6808082496 div.yiv6808082496attach-table div div a
{text-decoration:none;}#yiv6808082496 div.yiv6808082496attach-table
{width:400px;}#yiv6808082496 div.yiv6808082496file-title a, #yiv6808082496
div.yiv6808082496file-title a:active, #yiv6808082496
div.yiv6808082496file-title a:hover, #yiv6808082496 div.yiv6808082496file-title
a:visited {text-decoration:none;}#yiv6808082496 div.yiv6808082496photo-title a,
#yiv6808082496 div.yiv6808082496photo-title a:active, #yiv6808082496
div.yiv6808082496photo-title a:hover, #yiv6808082496
div.yiv6808082496photo-title a:visited {text-decoration:none;}#yiv6808082496
div#yiv6808082496ygrp-mlmsg #yiv6808082496ygrp-msg p a
span.yiv6808082496yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6808082496
.yiv6808082496green {color:#628c2a;}#yiv6808082496 .yiv6808082496MsoNormal
{margin:0 0 0 0;}#yiv6808082496 o {font-size:0;}#yiv6808082496
#yiv6808082496photos div {float:left;width:72px;}#yiv6808082496
#yiv6808082496photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6808082496
#yiv6808082496photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6808082496
#yiv6808082496reco-category {font-size:77%;}#yiv6808082496
#yiv6808082496reco-desc {font-size:77%;}#yiv6808082496 .yiv6808082496replbq
{margin:4px;}#yiv6808082496 #yiv6808082496ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6808082496 #yiv6808082496ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6808082496
#yiv6808082496ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6808082496
#yiv6808082496ygrp-mlmsg select, #yiv6808082496 input, #yiv6808082496 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6808082496
#yiv6808082496ygrp-mlmsg pre, #yiv6808082496 code {font:115%
monospace;}#yiv6808082496 #yiv6808082496ygrp-mlmsg *
{line-height:1.22em;}#yiv6808082496 #yiv6808082496ygrp-mlmsg #yiv6808082496logo
{padding-bottom:10px;}#yiv6808082496 #yiv6808082496ygrp-msg p a
{font-family:Verdana;}#yiv6808082496 #yiv6808082496ygrp-msg
p#yiv6808082496attach-count span {color:#1E66AE;font-weight:700;}#yiv6808082496
#yiv6808082496ygrp-reco #yiv6808082496reco-head
{color:#ff7900;font-weight:700;}#yiv6808082496 #yiv6808082496ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6808082496 #yiv6808082496ygrp-sponsor
#yiv6808082496ov li a {font-size:130%;text-decoration:none;}#yiv6808082496
#yiv6808082496ygrp-sponsor #yiv6808082496ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6808082496
#yiv6808082496ygrp-sponsor #yiv6808082496ov ul {margin:0;padding:0 0 0
8px;}#yiv6808082496 #yiv6808082496ygrp-text
{font-family:Georgia;}#yiv6808082496 #yiv6808082496ygrp-text p {margin:0 0 1em
0;}#yiv6808082496 #yiv6808082496ygrp-text tt {font-size:120%;}#yiv6808082496
#yiv6808082496ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6808082496
Sum Komulatif_toby.xlsm
Description: application/vnd.ms-excel.macroenabled.12
