Bukan, Table uk filenya lebih kecil dari Range .... coba cek lamp. Salam,HK
Sent from Yahoo Mail on Android On Thu, Sep 13, 2018 at 13:05, Tio Ali [email protected] [belajar-excel]<[email protected]> wrote: Oh ya. Maaf salah paham. Berarti format sebagai table ukurannya lebih besar ya dari range.... Pada Kamis, 13 September 2018 12.43.54 WIB, Tio Adi Bayu Adjie [email protected] [belajar-excel] <[email protected]> menulis: Maaf Pak Hendrik. Maksud saya dari sisi penampilan. Penampilan sebagai format as table , tampilannya bagus. Nah, apakah tampilan bagus seperti itu memperbesar memory atau file size jadi lebih besar ? Kalau range tampilannya tidak bagus.. Thank you Best Regards, Tio From: [email protected] [mailto:[email protected]] Sent: 13 September 2018 11:07 To: [email protected] Subject: Re: [belajar-excel] Format as table di file macro (VBA) [2 Attachments] Hai Tio, Hasil percobaan saya, antara Range dgn Table ternyata lebih kecil tabel ukuran filenya, walaupun tampilan Table lebih menarik. File terlampir. Salam, HK Sent from Yahoo Mail on Android On Thu, Sep 13, 2018 at 7:34, Tio Ali [email protected] [belajar-excel] <[email protected]> wrote: Salam B_-Exceller. Kalau pembuatan database dengan pakai macro (VBA) maka penggunaan memory dan ukuran file harus selalu diperhatikan. Pertanyaannya. Apakah kalau table dibuat dengan 'format as table" -yang ada warna warni selang-seling- itu membuat ukuran file besar atau memory jadi membengkak ? Terima kasih bimbingannya. #yiv7522284859 #yiv7522284859 -- #yiv7522284859ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7522284859 #yiv7522284859ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7522284859 #yiv7522284859ygrp-mkp #yiv7522284859hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7522284859 #yiv7522284859ygrp-mkp #yiv7522284859ads {margin-bottom:10px;}#yiv7522284859 #yiv7522284859ygrp-mkp .yiv7522284859ad {padding:0 0;}#yiv7522284859 #yiv7522284859ygrp-mkp .yiv7522284859ad p {margin:0;}#yiv7522284859 #yiv7522284859ygrp-mkp .yiv7522284859ad a {color:#0000ff;text-decoration:none;}#yiv7522284859 #yiv7522284859ygrp-sponsor #yiv7522284859ygrp-lc {font-family:Arial;}#yiv7522284859 #yiv7522284859ygrp-sponsor #yiv7522284859ygrp-lc #yiv7522284859hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7522284859 #yiv7522284859ygrp-sponsor #yiv7522284859ygrp-lc .yiv7522284859ad {margin-bottom:10px;padding:0 0;}#yiv7522284859 #yiv7522284859actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7522284859 #yiv7522284859activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7522284859 #yiv7522284859activity span {font-weight:700;}#yiv7522284859 #yiv7522284859activity span:first-child {text-transform:uppercase;}#yiv7522284859 #yiv7522284859activity span a {color:#5085b6;text-decoration:none;}#yiv7522284859 #yiv7522284859activity span span {color:#ff7900;}#yiv7522284859 #yiv7522284859activity span .yiv7522284859underline {text-decoration:underline;}#yiv7522284859 .yiv7522284859attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7522284859 .yiv7522284859attach div a {text-decoration:none;}#yiv7522284859 .yiv7522284859attach img {border:none;padding-right:5px;}#yiv7522284859 .yiv7522284859attach label {display:block;margin-bottom:5px;}#yiv7522284859 .yiv7522284859attach label a {text-decoration:none;}#yiv7522284859 blockquote {margin:0 0 0 4px;}#yiv7522284859 .yiv7522284859bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7522284859 .yiv7522284859bold a {text-decoration:none;}#yiv7522284859 dd.yiv7522284859last p a {font-family:Verdana;font-weight:700;}#yiv7522284859 dd.yiv7522284859last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7522284859 dd.yiv7522284859last p span.yiv7522284859yshortcuts {margin-right:0;}#yiv7522284859 div.yiv7522284859attach-table div div a {text-decoration:none;}#yiv7522284859 div.yiv7522284859attach-table {width:400px;}#yiv7522284859 div.yiv7522284859file-title a, #yiv7522284859 div.yiv7522284859file-title a:active, #yiv7522284859 div.yiv7522284859file-title a:hover, #yiv7522284859 div.yiv7522284859file-title a:visited {text-decoration:none;}#yiv7522284859 div.yiv7522284859photo-title a, #yiv7522284859 div.yiv7522284859photo-title a:active, #yiv7522284859 div.yiv7522284859photo-title a:hover, #yiv7522284859 div.yiv7522284859photo-title a:visited {text-decoration:none;}#yiv7522284859 div#yiv7522284859ygrp-mlmsg #yiv7522284859ygrp-msg p a span.yiv7522284859yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7522284859 .yiv7522284859green {color:#628c2a;}#yiv7522284859 .yiv7522284859MsoNormal {margin:0 0 0 0;}#yiv7522284859 o {font-size:0;}#yiv7522284859 #yiv7522284859photos div {float:left;width:72px;}#yiv7522284859 #yiv7522284859photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7522284859 #yiv7522284859photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7522284859 #yiv7522284859reco-category {font-size:77%;}#yiv7522284859 #yiv7522284859reco-desc {font-size:77%;}#yiv7522284859 .yiv7522284859replbq {margin:4px;}#yiv7522284859 #yiv7522284859ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7522284859 #yiv7522284859ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7522284859 #yiv7522284859ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7522284859 #yiv7522284859ygrp-mlmsg select, #yiv7522284859 input, #yiv7522284859 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7522284859 #yiv7522284859ygrp-mlmsg pre, #yiv7522284859 code {font:115% monospace;}#yiv7522284859 #yiv7522284859ygrp-mlmsg * {line-height:1.22em;}#yiv7522284859 #yiv7522284859ygrp-mlmsg #yiv7522284859logo {padding-bottom:10px;}#yiv7522284859 #yiv7522284859ygrp-msg p a {font-family:Verdana;}#yiv7522284859 #yiv7522284859ygrp-msg p#yiv7522284859attach-count span {color:#1E66AE;font-weight:700;}#yiv7522284859 #yiv7522284859ygrp-reco #yiv7522284859reco-head {color:#ff7900;font-weight:700;}#yiv7522284859 #yiv7522284859ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7522284859 #yiv7522284859ygrp-sponsor #yiv7522284859ov li a {font-size:130%;text-decoration:none;}#yiv7522284859 #yiv7522284859ygrp-sponsor #yiv7522284859ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7522284859 #yiv7522284859ygrp-sponsor #yiv7522284859ov ul {margin:0;padding:0 0 0 8px;}#yiv7522284859 #yiv7522284859ygrp-text {font-family:Georgia;}#yiv7522284859 #yiv7522284859ygrp-text p {margin:0 0 1em 0;}#yiv7522284859 #yiv7522284859ygrp-text tt {font-size:120%;}#yiv7522284859 #yiv7522284859ygrp-vital ul li:last-child {border-right:none !important;}#yiv7522284859
