Hai Matzen, Supaya ga gelap ga perlu pake Vb...manual saja. Tekan tombol Ctrl End secara bersamaan maka kita akan sampai pada data baris terakhir (pojok kanan bawah), tinggal turunin satu baris. Posisi sel pointer bisa dimana saja asal dalam Worksheet yang sama. Salam, HK
From: "'Subroto, Matzen' [email protected] [belajar-excel]" <[email protected]> To: "[email protected]" <[email protected]> Sent: Wednesday, 27 January 2016, 8:16 Subject: RE: [belajar-excel] Temukan baris kosong diurutan terakhir data menggunakan VB [1 Attachment] Dear Mr. HK Terima kasih, atas Ilmunya, Cuma karena saya GELAP dengan VB, gimana nerapin andai saya punya data seperti terlampir Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan Terima Kasih Matzen From: [email protected] [mailto:[email protected]] Sent: 26 Januari 2016 20:05 To: [email protected] Subject: Re: [belajar-excel] Temukan baris kosong diurutan terakhir data menggunakan VB Hai Matzen, Coba perintah ini untuk mencari baris kosong setelah data terakhir, LastRow = Range("A1").SpecialCells (xlLastCell).Offset (1,0).Row Salam, HK Sent from Samsung Mobile -------- Original message -------- From: "'Subroto, Matzen' [email protected] [belajar-excel]" Date:26/01/2016 4:15 PM (GMT+07:00) To: [email protected] Subject: [belajar-excel] Temukan baris kosong diurutan terakhir data menggunakan VB Dear Master Mohon Pencerahannye dengan VB menemukan baris kosong di urutan paling akhir data Terima kasih atas perhatian dan kerjasamanya, dan saya mohon maaf apabila ada kata-kata yang kurang berkenan Terima Kasih Matzen ____________________________________________________________________________ This email has been scanned by AkzoNobel for Viruses and Spam. For more information please contact your local IT Service Desk. ____________________________________________________________________________ #yiv9033849487 -- #yiv9033849487ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9033849487 #yiv9033849487ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9033849487 #yiv9033849487ygrp-mkp #yiv9033849487hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9033849487 #yiv9033849487ygrp-mkp #yiv9033849487ads {margin-bottom:10px;}#yiv9033849487 #yiv9033849487ygrp-mkp .yiv9033849487ad {padding:0 0;}#yiv9033849487 #yiv9033849487ygrp-mkp .yiv9033849487ad p {margin:0;}#yiv9033849487 #yiv9033849487ygrp-mkp .yiv9033849487ad a {color:#0000ff;text-decoration:none;}#yiv9033849487 #yiv9033849487ygrp-sponsor #yiv9033849487ygrp-lc {font-family:Arial;}#yiv9033849487 #yiv9033849487ygrp-sponsor #yiv9033849487ygrp-lc #yiv9033849487hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9033849487 #yiv9033849487ygrp-sponsor #yiv9033849487ygrp-lc .yiv9033849487ad {margin-bottom:10px;padding:0 0;}#yiv9033849487 #yiv9033849487actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9033849487 #yiv9033849487activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9033849487 #yiv9033849487activity span {font-weight:700;}#yiv9033849487 #yiv9033849487activity span:first-child {text-transform:uppercase;}#yiv9033849487 #yiv9033849487activity span a {color:#5085b6;text-decoration:none;}#yiv9033849487 #yiv9033849487activity span span {color:#ff7900;}#yiv9033849487 #yiv9033849487activity span .yiv9033849487underline {text-decoration:underline;}#yiv9033849487 .yiv9033849487attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9033849487 .yiv9033849487attach div a {text-decoration:none;}#yiv9033849487 .yiv9033849487attach img {border:none;padding-right:5px;}#yiv9033849487 .yiv9033849487attach label {display:block;margin-bottom:5px;}#yiv9033849487 .yiv9033849487attach label a {text-decoration:none;}#yiv9033849487 blockquote {margin:0 0 0 4px;}#yiv9033849487 .yiv9033849487bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9033849487 .yiv9033849487bold a {text-decoration:none;}#yiv9033849487 dd.yiv9033849487last p a {font-family:Verdana;font-weight:700;}#yiv9033849487 dd.yiv9033849487last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9033849487 dd.yiv9033849487last p span.yiv9033849487yshortcuts {margin-right:0;}#yiv9033849487 div.yiv9033849487attach-table div div a {text-decoration:none;}#yiv9033849487 div.yiv9033849487attach-table {width:400px;}#yiv9033849487 div.yiv9033849487file-title a, #yiv9033849487 div.yiv9033849487file-title a:active, #yiv9033849487 div.yiv9033849487file-title a:hover, #yiv9033849487 div.yiv9033849487file-title a:visited {text-decoration:none;}#yiv9033849487 div.yiv9033849487photo-title a, #yiv9033849487 div.yiv9033849487photo-title a:active, #yiv9033849487 div.yiv9033849487photo-title a:hover, #yiv9033849487 div.yiv9033849487photo-title a:visited {text-decoration:none;}#yiv9033849487 div#yiv9033849487ygrp-mlmsg #yiv9033849487ygrp-msg p a span.yiv9033849487yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9033849487 .yiv9033849487green {color:#628c2a;}#yiv9033849487 .yiv9033849487MsoNormal {margin:0 0 0 0;}#yiv9033849487 o {font-size:0;}#yiv9033849487 #yiv9033849487photos div {float:left;width:72px;}#yiv9033849487 #yiv9033849487photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9033849487 #yiv9033849487photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9033849487 #yiv9033849487reco-category {font-size:77%;}#yiv9033849487 #yiv9033849487reco-desc {font-size:77%;}#yiv9033849487 .yiv9033849487replbq {margin:4px;}#yiv9033849487 #yiv9033849487ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9033849487 #yiv9033849487ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9033849487 #yiv9033849487ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9033849487 #yiv9033849487ygrp-mlmsg select, #yiv9033849487 input, #yiv9033849487 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9033849487 #yiv9033849487ygrp-mlmsg pre, #yiv9033849487 code {font:115% monospace;}#yiv9033849487 #yiv9033849487ygrp-mlmsg * {line-height:1.22em;}#yiv9033849487 #yiv9033849487ygrp-mlmsg #yiv9033849487logo {padding-bottom:10px;}#yiv9033849487 #yiv9033849487ygrp-msg p a {font-family:Verdana;}#yiv9033849487 #yiv9033849487ygrp-msg p#yiv9033849487attach-count span {color:#1E66AE;font-weight:700;}#yiv9033849487 #yiv9033849487ygrp-reco #yiv9033849487reco-head {color:#ff7900;font-weight:700;}#yiv9033849487 #yiv9033849487ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9033849487 #yiv9033849487ygrp-sponsor #yiv9033849487ov li a {font-size:130%;text-decoration:none;}#yiv9033849487 #yiv9033849487ygrp-sponsor #yiv9033849487ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9033849487 #yiv9033849487ygrp-sponsor #yiv9033849487ov ul {margin:0;padding:0 0 0 8px;}#yiv9033849487 #yiv9033849487ygrp-text {font-family:Georgia;}#yiv9033849487 #yiv9033849487ygrp-text p {margin:0 0 1em 0;}#yiv9033849487 #yiv9033849487ygrp-text tt {font-size:120%;}#yiv9033849487 #yiv9033849487ygrp-vital ul li:last-child {border-right:none !important;}#yiv9033849487
