Hai Mely,Untuk menghapus sel yang tidak terproteksi gunakan
perintah:Range("rangenya").ClearContents.
Contoh perintahnya:Range("B2:B3,D4,E4:G1000").ClearContents
Salam,HK
From: "Melyana Silaban [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Friday, 23 December 2016, 14:00
Subject: [belajar-excel] Membuat perintah macro untuk sheet yg areanya
terproteksi [1 Attachment]
Dear para master excel & macro,Mohon pencerahan untuk membuat perintah
macro yg berfungsi meng-remove data dari cell tertentu seperti dalam file
terlampir ini(warna hijau yg tidak terproteksi)Dalam file ini beberapa cell
terproteksi agar tidak ada tambahan sesuatu apapun di area tsb, sedangkan are
yg tidak ter-proteksi adalah area yg akan selalu perlu di-update. Di dalam
scrip macro yg saya buat contohnya ini tidak mampu untuk me-remove data di area
yg TIDAK TER-PROTEKSI.Hal ini dikarenakan keterbatasan pengetahuan saya tentang
macro ini. Untuk itulah mohon pencerahan dari para pakar macro untuk membantu
memberikansolusi terhadap permasalahan ini.Sebelumnya saya sampaikan banyak
terima kasih atas bantuan yg diberikan.
Salam,Mely #yiv0869456753 #yiv0869456753 -- #yiv0869456753ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0869456753
#yiv0869456753ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0869456753
#yiv0869456753ygrp-mkp #yiv0869456753hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0869456753 #yiv0869456753ygrp-mkp #yiv0869456753ads
{margin-bottom:10px;}#yiv0869456753 #yiv0869456753ygrp-mkp .yiv0869456753ad
{padding:0 0;}#yiv0869456753 #yiv0869456753ygrp-mkp .yiv0869456753ad p
{margin:0;}#yiv0869456753 #yiv0869456753ygrp-mkp .yiv0869456753ad a
{color:#0000ff;text-decoration:none;}#yiv0869456753 #yiv0869456753ygrp-sponsor
#yiv0869456753ygrp-lc {font-family:Arial;}#yiv0869456753
#yiv0869456753ygrp-sponsor #yiv0869456753ygrp-lc #yiv0869456753hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0869456753
#yiv0869456753ygrp-sponsor #yiv0869456753ygrp-lc .yiv0869456753ad
{margin-bottom:10px;padding:0 0;}#yiv0869456753 #yiv0869456753actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0869456753
#yiv0869456753activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0869456753
#yiv0869456753activity span {font-weight:700;}#yiv0869456753
#yiv0869456753activity span:first-child
{text-transform:uppercase;}#yiv0869456753 #yiv0869456753activity span a
{color:#5085b6;text-decoration:none;}#yiv0869456753 #yiv0869456753activity span
span {color:#ff7900;}#yiv0869456753 #yiv0869456753activity span
.yiv0869456753underline {text-decoration:underline;}#yiv0869456753
.yiv0869456753attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0869456753 .yiv0869456753attach div a
{text-decoration:none;}#yiv0869456753 .yiv0869456753attach img
{border:none;padding-right:5px;}#yiv0869456753 .yiv0869456753attach label
{display:block;margin-bottom:5px;}#yiv0869456753 .yiv0869456753attach label a
{text-decoration:none;}#yiv0869456753 blockquote {margin:0 0 0
4px;}#yiv0869456753 .yiv0869456753bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0869456753
.yiv0869456753bold a {text-decoration:none;}#yiv0869456753 dd.yiv0869456753last
p a {font-family:Verdana;font-weight:700;}#yiv0869456753 dd.yiv0869456753last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0869456753
dd.yiv0869456753last p span.yiv0869456753yshortcuts
{margin-right:0;}#yiv0869456753 div.yiv0869456753attach-table div div a
{text-decoration:none;}#yiv0869456753 div.yiv0869456753attach-table
{width:400px;}#yiv0869456753 div.yiv0869456753file-title a, #yiv0869456753
div.yiv0869456753file-title a:active, #yiv0869456753
div.yiv0869456753file-title a:hover, #yiv0869456753 div.yiv0869456753file-title
a:visited {text-decoration:none;}#yiv0869456753 div.yiv0869456753photo-title a,
#yiv0869456753 div.yiv0869456753photo-title a:active, #yiv0869456753
div.yiv0869456753photo-title a:hover, #yiv0869456753
div.yiv0869456753photo-title a:visited {text-decoration:none;}#yiv0869456753
div#yiv0869456753ygrp-mlmsg #yiv0869456753ygrp-msg p a
span.yiv0869456753yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0869456753
.yiv0869456753green {color:#628c2a;}#yiv0869456753 .yiv0869456753MsoNormal
{margin:0 0 0 0;}#yiv0869456753 o {font-size:0;}#yiv0869456753
#yiv0869456753photos div {float:left;width:72px;}#yiv0869456753
#yiv0869456753photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0869456753
#yiv0869456753photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0869456753
#yiv0869456753reco-category {font-size:77%;}#yiv0869456753
#yiv0869456753reco-desc {font-size:77%;}#yiv0869456753 .yiv0869456753replbq
{margin:4px;}#yiv0869456753 #yiv0869456753ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0869456753 #yiv0869456753ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0869456753
#yiv0869456753ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0869456753
#yiv0869456753ygrp-mlmsg select, #yiv0869456753 input, #yiv0869456753 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0869456753
#yiv0869456753ygrp-mlmsg pre, #yiv0869456753 code {font:115%
monospace;}#yiv0869456753 #yiv0869456753ygrp-mlmsg *
{line-height:1.22em;}#yiv0869456753 #yiv0869456753ygrp-mlmsg #yiv0869456753logo
{padding-bottom:10px;}#yiv0869456753 #yiv0869456753ygrp-msg p a
{font-family:Verdana;}#yiv0869456753 #yiv0869456753ygrp-msg
p#yiv0869456753attach-count span {color:#1E66AE;font-weight:700;}#yiv0869456753
#yiv0869456753ygrp-reco #yiv0869456753reco-head
{color:#ff7900;font-weight:700;}#yiv0869456753 #yiv0869456753ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0869456753 #yiv0869456753ygrp-sponsor
#yiv0869456753ov li a {font-size:130%;text-decoration:none;}#yiv0869456753
#yiv0869456753ygrp-sponsor #yiv0869456753ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0869456753
#yiv0869456753ygrp-sponsor #yiv0869456753ov ul {margin:0;padding:0 0 0
8px;}#yiv0869456753 #yiv0869456753ygrp-text
{font-family:Georgia;}#yiv0869456753 #yiv0869456753ygrp-text p {margin:0 0 1em
0;}#yiv0869456753 #yiv0869456753ygrp-text tt {font-size:120%;}#yiv0869456753
#yiv0869456753ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0869456753
