Dear Mr Samsudin,
Mungkin seperti ini maksud MR. Kid. Semoga nggak salah yah. Salam, DD Note : Formula di H8 saya ganti yah. From: [email protected] [mailto:[email protected]] Sent: 02 November 2015 7:26 To: [email protected] Subject: RE: [belajar-excel] Belajar Makro Dear Mr. Kid, Terima kasih pencerahannya akan tetapi saya tidak mudeng bagaimana mengaplikasikannya maksud tersebut (maklum saya baru mau mencoba bahasa vba). Terima kasih Samsudin From: [email protected] [mailto:[email protected]] Sent: Monday, November 02, 2015 2:29 AM To: BeExcel Subject: Re: [belajar-excel] Belajar Makro Hai Samsudin, Coba semua proses Find ditambahkan inputan di parameter lookat bernilai xlWhole. Syntax methods (fungsi) Find milik object range yang berbunyi : expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat) untuk menggunakan LookAt bernilai xlwhole, tetapi tidak ada nilai untuk After dan LookIn, jadinya berbunyi : expression.Find(What, LookAt:=xlwhole) Wassalam, Kid On Sat, Oct 31, 2015 at 8:40 AM, Samsudin [email protected] [belajar-excel] <[email protected]> wrote: Dear Master Excel, Saya lagi mulai belajar makro dengan Excel dan saya mencoba menggunakan salah satu karya alm. Ibu Siti (Presensi), setelah saya aplikasi atau di tiru dengan beberapa modifikasi, saya mempunyai kendala sebagai berikut : 1. Masalah ID, ada ID pada saat input bermasalah , yaitu ID : 8, 130, dan 827 2. Masalah row, pada saat input bermasalah pada baris : 16, 18 , 19 Sebenar saya sudah mencoba mengotak-atik dengan menggunakan fungsi offset menjadi vlookup, tetapi tidak berhasil pada bahasa vba. Demikian kendalanya dan mohon bantuannya kepada master Excel untuk menyelesaikan kendala ini dan sebelumnya diucapkan banyak terima kasih. Terima kasih Samsudin --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed i n this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy. --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy.
PRESENSI.XLSB
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
