Mas Prasaja, sebenarnya kalo ada contoh sebagian atau dummy spreadsheet lebih bagus. coba rumah code menjadi:
Hitung=0 for i = 1 to Total Hitung =Hitung+Abs(.Cells((4 * i), (2 + n))) - Abs(.Cells((4 * i),(3 + n))) next i #dikirim_pakai_mail.yahoo.com_tanpa_pulsa# -------------------------------------------- On Mon, 4/12/17, prasaja_sat...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: Subject: [belajar-excel] Nilai Komulatif dari Array Data (VBA) To: belajar-excel@yahoogroups.com Date: Monday, 4 December, 2017, 11:43 AM Asslamu'alaimum Wr.Wb Be Exceller Masih berkaitan dengan Array nih, saya punya kode vba sebagai berikut: for i = 1 to Total Hitung =Abs(.Cells((4 * i), (2 + n))) - Abs(.Cells((4 * i), (3 + n))) next i Yg saya ingin tanyakan adalah : Saya ingin membuat variable nilai komulatif dari hasil diatas jadi nanti saya ingin menambahkan per tiap hasil variable "Hitung" ditambahkan ke hasil variable "Hitung" berikutnya nilkom1 = ((hitungke1 + Hitungke2),,,nilkkom2 = (hitungke2 + hitungke3),,,, nilkom3 = (hitungke3 + hitungke4),,,,dst). Tadinya saya buatnya seperti ini : for i = 1 to Total NilaiKomulatif = Hitung(i) + Hitung(i+1) next i tapi sayang sekali gak bisa. Mungkin teman - teman bisa membantu. Jaakallah khair sebelumnya Wasslamu'alaikum wr.wb #yiv5541997250 #yiv5541997250 -- #yiv5541997250ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv5541997250 #yiv5541997250ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv5541997250 #yiv5541997250ygrp-mkp #yiv5541997250hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv5541997250 #yiv5541997250ygrp-mkp #yiv5541997250ads { margin-bottom:10px;} #yiv5541997250 #yiv5541997250ygrp-mkp .yiv5541997250ad { padding:0 0;} #yiv5541997250 #yiv5541997250ygrp-mkp .yiv5541997250ad p { margin:0;} #yiv5541997250 #yiv5541997250ygrp-mkp .yiv5541997250ad a { color:#0000ff;text-decoration:none;} #yiv5541997250 #yiv5541997250ygrp-sponsor #yiv5541997250ygrp-lc { font-family:Arial;} #yiv5541997250 #yiv5541997250ygrp-sponsor #yiv5541997250ygrp-lc #yiv5541997250hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv5541997250 #yiv5541997250ygrp-sponsor #yiv5541997250ygrp-lc .yiv5541997250ad { margin-bottom:10px;padding:0 0;} #yiv5541997250 #yiv5541997250actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv5541997250 #yiv5541997250activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv5541997250 #yiv5541997250activity span { font-weight:700;} #yiv5541997250 #yiv5541997250activity span:first-child { text-transform:uppercase;} #yiv5541997250 #yiv5541997250activity span a { color:#5085b6;text-decoration:none;} #yiv5541997250 #yiv5541997250activity span span { color:#ff7900;} #yiv5541997250 #yiv5541997250activity span .yiv5541997250underline { text-decoration:underline;} #yiv5541997250 .yiv5541997250attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv5541997250 .yiv5541997250attach div a { text-decoration:none;} #yiv5541997250 .yiv5541997250attach img { border:none;padding-right:5px;} #yiv5541997250 .yiv5541997250attach label { display:block;margin-bottom:5px;} #yiv5541997250 .yiv5541997250attach label a { text-decoration:none;} #yiv5541997250 blockquote { margin:0 0 0 4px;} #yiv5541997250 .yiv5541997250bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv5541997250 .yiv5541997250bold a { text-decoration:none;} #yiv5541997250 dd.yiv5541997250last p a { font-family:Verdana;font-weight:700;} #yiv5541997250 dd.yiv5541997250last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv5541997250 dd.yiv5541997250last p span.yiv5541997250yshortcuts { margin-right:0;} #yiv5541997250 div.yiv5541997250attach-table div div a { text-decoration:none;} #yiv5541997250 div.yiv5541997250attach-table { width:400px;} #yiv5541997250 div.yiv5541997250file-title a, #yiv5541997250 div.yiv5541997250file-title a:active, #yiv5541997250 div.yiv5541997250file-title a:hover, #yiv5541997250 div.yiv5541997250file-title a:visited { text-decoration:none;} #yiv5541997250 div.yiv5541997250photo-title a, #yiv5541997250 div.yiv5541997250photo-title a:active, #yiv5541997250 div.yiv5541997250photo-title a:hover, #yiv5541997250 div.yiv5541997250photo-title a:visited { text-decoration:none;} #yiv5541997250 div#yiv5541997250ygrp-mlmsg #yiv5541997250ygrp-msg p a span.yiv5541997250yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv5541997250 .yiv5541997250green { color:#628c2a;} #yiv5541997250 .yiv5541997250MsoNormal { margin:0 0 0 0;} #yiv5541997250 o { font-size:0;} #yiv5541997250 #yiv5541997250photos div { float:left;width:72px;} #yiv5541997250 #yiv5541997250photos div div { border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;} #yiv5541997250 #yiv5541997250photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv5541997250 #yiv5541997250reco-category { font-size:77%;} #yiv5541997250 #yiv5541997250reco-desc { font-size:77%;} #yiv5541997250 .yiv5541997250replbq { margin:4px;} #yiv5541997250 #yiv5541997250ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv5541997250 #yiv5541997250ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv5541997250 #yiv5541997250ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv5541997250 #yiv5541997250ygrp-mlmsg select, #yiv5541997250 input, #yiv5541997250 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv5541997250 #yiv5541997250ygrp-mlmsg pre, #yiv5541997250 code { font:115% monospace;} #yiv5541997250 #yiv5541997250ygrp-mlmsg * { line-height:1.22em;} #yiv5541997250 #yiv5541997250ygrp-mlmsg #yiv5541997250logo { padding-bottom:10px;} #yiv5541997250 #yiv5541997250ygrp-msg p a { font-family:Verdana;} #yiv5541997250 #yiv5541997250ygrp-msg p#yiv5541997250attach-count span { color:#1E66AE;font-weight:700;} #yiv5541997250 #yiv5541997250ygrp-reco #yiv5541997250reco-head { color:#ff7900;font-weight:700;} #yiv5541997250 #yiv5541997250ygrp-reco { margin-bottom:20px;padding:0px;} #yiv5541997250 #yiv5541997250ygrp-sponsor #yiv5541997250ov li a { font-size:130%;text-decoration:none;} #yiv5541997250 #yiv5541997250ygrp-sponsor #yiv5541997250ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv5541997250 #yiv5541997250ygrp-sponsor #yiv5541997250ov ul { margin:0;padding:0 0 0 8px;} #yiv5541997250 #yiv5541997250ygrp-text { font-family:Georgia;} #yiv5541997250 #yiv5541997250ygrp-text p { margin:0 0 1em 0;} #yiv5541997250 #yiv5541997250ygrp-text tt { font-size:120%;} #yiv5541997250 #yiv5541997250ygrp-vital ul li:last-child { border-right:none !important; } #yiv5541997250