Coba tambahkan 2 perintah berikut ini:
Set rngGabung = Sheets("Gabung").Range("A2").CurrentRegion
rngGabung.Value = rngGabung.value
seblm Application.CutCopyMode = False
Salam,HKSent from Yahoo Mail on Android On Wed, Mar 22, 2017 at 14:37, [email protected] [belajar-excel]<[email protected]> wrote: Yth. Pakar Excel Mohon bantuannya , Saya dapat barisan code macro berikut (dari milis ini juga) : Sub Gabung() Dim rngGabung As Range Dim sh As Worksheet Dim rngsh As Range Dim brs As Long Set rngGabung = Sheets("Gabung").Range("A2").CurrentRegion Set rngGabung = rngGabung.Offset(1, 0).Resize(rngGabung.Rows.Count - 1) Application.ScreenUpdating = False rngGabung.ClearContents For Each sh In Worksheets If sh.Name <> "Gabung" Then If sh.Name <> "nim_nama" Then If sh.Name <> "a2" Then If sh.Name <> "pivot_table" Then Set rngsh = sh.Range("A2").CurrentRegion Set rngsh = rngsh.Offset(1, 0).Resize(rngsh.Rows.Count - 1) brs = WorksheetFunction.CountA(Sheets("Gabung").Columns("A:A")) rngsh.Copy Sheets("Gabung").Range("A" & brs + 1) End If End If End If End If Next sh Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Barisan code macro tersebut jika diterapkan hasilnya "copy paste" .. keinginan saya bagaimana biar hasilnya "copy VALUE" saja, mohon bantuannya merevisi barisan code macro tersebut .. Terima kasih ari #yiv9321595764 #yiv9321595764 -- #yiv9321595764ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9321595764 #yiv9321595764ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9321595764 #yiv9321595764ygrp-mkp #yiv9321595764hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9321595764 #yiv9321595764ygrp-mkp #yiv9321595764ads {margin-bottom:10px;}#yiv9321595764 #yiv9321595764ygrp-mkp .yiv9321595764ad {padding:0 0;}#yiv9321595764 #yiv9321595764ygrp-mkp .yiv9321595764ad p {margin:0;}#yiv9321595764 #yiv9321595764ygrp-mkp .yiv9321595764ad a {color:#0000ff;text-decoration:none;}#yiv9321595764 #yiv9321595764ygrp-sponsor #yiv9321595764ygrp-lc {font-family:Arial;}#yiv9321595764 #yiv9321595764ygrp-sponsor #yiv9321595764ygrp-lc #yiv9321595764hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9321595764 #yiv9321595764ygrp-sponsor #yiv9321595764ygrp-lc .yiv9321595764ad {margin-bottom:10px;padding:0 0;}#yiv9321595764 #yiv9321595764actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9321595764 #yiv9321595764activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9321595764 #yiv9321595764activity span {font-weight:700;}#yiv9321595764 #yiv9321595764activity span:first-child {text-transform:uppercase;}#yiv9321595764 #yiv9321595764activity span a {color:#5085b6;text-decoration:none;}#yiv9321595764 #yiv9321595764activity span span {color:#ff7900;}#yiv9321595764 #yiv9321595764activity span .yiv9321595764underline {text-decoration:underline;}#yiv9321595764 .yiv9321595764attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9321595764 .yiv9321595764attach div a {text-decoration:none;}#yiv9321595764 .yiv9321595764attach img {border:none;padding-right:5px;}#yiv9321595764 .yiv9321595764attach label {display:block;margin-bottom:5px;}#yiv9321595764 .yiv9321595764attach label a {text-decoration:none;}#yiv9321595764 blockquote {margin:0 0 0 4px;}#yiv9321595764 .yiv9321595764bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9321595764 .yiv9321595764bold a {text-decoration:none;}#yiv9321595764 dd.yiv9321595764last p a {font-family:Verdana;font-weight:700;}#yiv9321595764 dd.yiv9321595764last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9321595764 dd.yiv9321595764last p span.yiv9321595764yshortcuts {margin-right:0;}#yiv9321595764 div.yiv9321595764attach-table div div a {text-decoration:none;}#yiv9321595764 div.yiv9321595764attach-table {width:400px;}#yiv9321595764 div.yiv9321595764file-title a, #yiv9321595764 div.yiv9321595764file-title a:active, #yiv9321595764 div.yiv9321595764file-title a:hover, #yiv9321595764 div.yiv9321595764file-title a:visited {text-decoration:none;}#yiv9321595764 div.yiv9321595764photo-title a, #yiv9321595764 div.yiv9321595764photo-title a:active, #yiv9321595764 div.yiv9321595764photo-title a:hover, #yiv9321595764 div.yiv9321595764photo-title a:visited {text-decoration:none;}#yiv9321595764 div#yiv9321595764ygrp-mlmsg #yiv9321595764ygrp-msg p a span.yiv9321595764yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9321595764 .yiv9321595764green {color:#628c2a;}#yiv9321595764 .yiv9321595764MsoNormal {margin:0 0 0 0;}#yiv9321595764 o {font-size:0;}#yiv9321595764 #yiv9321595764photos div {float:left;width:72px;}#yiv9321595764 #yiv9321595764photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9321595764 #yiv9321595764photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9321595764 #yiv9321595764reco-category {font-size:77%;}#yiv9321595764 #yiv9321595764reco-desc {font-size:77%;}#yiv9321595764 .yiv9321595764replbq {margin:4px;}#yiv9321595764 #yiv9321595764ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9321595764 #yiv9321595764ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9321595764 #yiv9321595764ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9321595764 #yiv9321595764ygrp-mlmsg select, #yiv9321595764 input, #yiv9321595764 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9321595764 #yiv9321595764ygrp-mlmsg pre, #yiv9321595764 code {font:115% monospace;}#yiv9321595764 #yiv9321595764ygrp-mlmsg * {line-height:1.22em;}#yiv9321595764 #yiv9321595764ygrp-mlmsg #yiv9321595764logo {padding-bottom:10px;}#yiv9321595764 #yiv9321595764ygrp-msg p a {font-family:Verdana;}#yiv9321595764 #yiv9321595764ygrp-msg p#yiv9321595764attach-count span {color:#1E66AE;font-weight:700;}#yiv9321595764 #yiv9321595764ygrp-reco #yiv9321595764reco-head {color:#ff7900;font-weight:700;}#yiv9321595764 #yiv9321595764ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9321595764 #yiv9321595764ygrp-sponsor #yiv9321595764ov li a {font-size:130%;text-decoration:none;}#yiv9321595764 #yiv9321595764ygrp-sponsor #yiv9321595764ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9321595764 #yiv9321595764ygrp-sponsor #yiv9321595764ov ul {margin:0;padding:0 0 0 8px;}#yiv9321595764 #yiv9321595764ygrp-text {font-family:Georgia;}#yiv9321595764 #yiv9321595764ygrp-text p {margin:0 0 1em 0;}#yiv9321595764 #yiv9321595764ygrp-text tt {font-size:120%;}#yiv9321595764 #yiv9321595764ygrp-vital ul li:last-child {border-right:none !important;}#yiv9321595764
