Hai Seismica,Coba cek apakah ada kolom (field) yang dihide atau judul kolom
yang kosong.Akan lebih jelas kalau dilampirkan dummy filenya.
Salam,HK
Sent from Yahoo Mail on Android
On Wed, Jan 31, 2018 at 13:50, Zerlinda Seismica seism...@yahoo.com
[belajar-excel]<belajar-excel@yahoogroups.com> wrote:
Assalamualaikum wrwb
Mohon izin lagi bertanya setelah agak vakum....boleh ya..saya Lagi belajar
macro karena kalo pake pivot saja agak susah. Saya lagi buat adv filter
rekasaya dari yg sudah ada disesuaikan dengan kebutuhan. Tapi ada kendala
muncul The Extract Range Has A Missing Or Illegal Field Name error 1004.
Padahal tabelnya percis dan mirip cuma beda nama sheet dan isi itemnya beda.
Tapi kenapa masih timbul eror The Extract Range Has A Missing Or Illegal Field
Name error 1004.
seperti ini
' ini kode untuk Advance Filternya db_xx_ST
ThisWorkbook.Sheets("db_xx_ST").Range("A3").CurrentRegion.AdvancedFilter
Action:=xlFilterCopy, _
CriteriaRange:=ThisWorkbook.Sheets("data_report").Range("c1:c2"), _
CopyToRange:=Range("AC3:AJ3"), Unique:=False
' ini kode untuk Advance Filternya db_xx_RT
ThisWorkbook.Sheets("db_xx_RT").Range("A3").CurrentRegion.AdvancedFilter
Action:=xlFilterCopy, _
CriteriaRange:=ThisWorkbook.Sheets("data_report").Range("c1:c2"), _
CopyToRange:=Range("ak3:aQ3"), Unique:=False
***** Hasil copy paste filter berada pada sheet yang sama
sintak yg atas yg muncul eror...pola sheet pada db_xx_ST dan db_xx_RT saya
pastikan sama percis tidak mungkin beda.Kalo sintax yang diatas dihapus
proggram bisa runing tapi kalo sintax diatas saya masukan akan muncul
eror.Semoga uraian diatas bisa membantu maksud dari permasalahan ini...
Mohon petujuk dari bapak ibu..WassalamSeismica
#yiv8514211336 #yiv8514211336 -- #yiv8514211336ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8514211336
#yiv8514211336ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8514211336
#yiv8514211336ygrp-mkp #yiv8514211336hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8514211336 #yiv8514211336ygrp-mkp #yiv8514211336ads
{margin-bottom:10px;}#yiv8514211336 #yiv8514211336ygrp-mkp .yiv8514211336ad
{padding:0 0;}#yiv8514211336 #yiv8514211336ygrp-mkp .yiv8514211336ad p
{margin:0;}#yiv8514211336 #yiv8514211336ygrp-mkp .yiv8514211336ad a
{color:#0000ff;text-decoration:none;}#yiv8514211336 #yiv8514211336ygrp-sponsor
#yiv8514211336ygrp-lc {font-family:Arial;}#yiv8514211336
#yiv8514211336ygrp-sponsor #yiv8514211336ygrp-lc #yiv8514211336hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8514211336
#yiv8514211336ygrp-sponsor #yiv8514211336ygrp-lc .yiv8514211336ad
{margin-bottom:10px;padding:0 0;}#yiv8514211336 #yiv8514211336actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8514211336
#yiv8514211336activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8514211336
#yiv8514211336activity span {font-weight:700;}#yiv8514211336
#yiv8514211336activity span:first-child
{text-transform:uppercase;}#yiv8514211336 #yiv8514211336activity span a
{color:#5085b6;text-decoration:none;}#yiv8514211336 #yiv8514211336activity span
span {color:#ff7900;}#yiv8514211336 #yiv8514211336activity span
.yiv8514211336underline {text-decoration:underline;}#yiv8514211336
.yiv8514211336attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8514211336 .yiv8514211336attach div a
{text-decoration:none;}#yiv8514211336 .yiv8514211336attach img
{border:none;padding-right:5px;}#yiv8514211336 .yiv8514211336attach label
{display:block;margin-bottom:5px;}#yiv8514211336 .yiv8514211336attach label a
{text-decoration:none;}#yiv8514211336 blockquote {margin:0 0 0
4px;}#yiv8514211336 .yiv8514211336bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8514211336
.yiv8514211336bold a {text-decoration:none;}#yiv8514211336 dd.yiv8514211336last
p a {font-family:Verdana;font-weight:700;}#yiv8514211336 dd.yiv8514211336last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8514211336
dd.yiv8514211336last p span.yiv8514211336yshortcuts
{margin-right:0;}#yiv8514211336 div.yiv8514211336attach-table div div a
{text-decoration:none;}#yiv8514211336 div.yiv8514211336attach-table
{width:400px;}#yiv8514211336 div.yiv8514211336file-title a, #yiv8514211336
div.yiv8514211336file-title a:active, #yiv8514211336
div.yiv8514211336file-title a:hover, #yiv8514211336 div.yiv8514211336file-title
a:visited {text-decoration:none;}#yiv8514211336 div.yiv8514211336photo-title a,
#yiv8514211336 div.yiv8514211336photo-title a:active, #yiv8514211336
div.yiv8514211336photo-title a:hover, #yiv8514211336
div.yiv8514211336photo-title a:visited {text-decoration:none;}#yiv8514211336
div#yiv8514211336ygrp-mlmsg #yiv8514211336ygrp-msg p a
span.yiv8514211336yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8514211336
.yiv8514211336green {color:#628c2a;}#yiv8514211336 .yiv8514211336MsoNormal
{margin:0 0 0 0;}#yiv8514211336 o {font-size:0;}#yiv8514211336
#yiv8514211336photos div {float:left;width:72px;}#yiv8514211336
#yiv8514211336photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv8514211336
#yiv8514211336photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8514211336
#yiv8514211336reco-category {font-size:77%;}#yiv8514211336
#yiv8514211336reco-desc {font-size:77%;}#yiv8514211336 .yiv8514211336replbq
{margin:4px;}#yiv8514211336 #yiv8514211336ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8514211336 #yiv8514211336ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8514211336
#yiv8514211336ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8514211336
#yiv8514211336ygrp-mlmsg select, #yiv8514211336 input, #yiv8514211336 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8514211336
#yiv8514211336ygrp-mlmsg pre, #yiv8514211336 code {font:115%
monospace;}#yiv8514211336 #yiv8514211336ygrp-mlmsg *
{line-height:1.22em;}#yiv8514211336 #yiv8514211336ygrp-mlmsg #yiv8514211336logo
{padding-bottom:10px;}#yiv8514211336 #yiv8514211336ygrp-msg p a
{font-family:Verdana;}#yiv8514211336 #yiv8514211336ygrp-msg
p#yiv8514211336attach-count span {color:#1E66AE;font-weight:700;}#yiv8514211336
#yiv8514211336ygrp-reco #yiv8514211336reco-head
{color:#ff7900;font-weight:700;}#yiv8514211336 #yiv8514211336ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8514211336 #yiv8514211336ygrp-sponsor
#yiv8514211336ov li a {font-size:130%;text-decoration:none;}#yiv8514211336
#yiv8514211336ygrp-sponsor #yiv8514211336ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8514211336
#yiv8514211336ygrp-sponsor #yiv8514211336ov ul {margin:0;padding:0 0 0
8px;}#yiv8514211336 #yiv8514211336ygrp-text
{font-family:Georgia;}#yiv8514211336 #yiv8514211336ygrp-text p {margin:0 0 1em
0;}#yiv8514211336 #yiv8514211336ygrp-text tt {font-size:120%;}#yiv8514211336
#yiv8514211336ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8514211336
