Dear Mr Toby,
Sukses, terima kasih banyak. Salam, DD From: Toby kenzo [email protected] [belajar-excel] [mailto:[email protected]] Sent: 05 Mei 2015 11:31 To: [email protected] Subject: Bls: [belajar-excel] Hide ROW Dear DD, Coba kamu tambahkan formula ini sebelum formula if Sheet5.Activate Range(Cells(21, 2), Cells(ans, 2)).EntireRow.Hidden = False TerimaKasih. Pada Selasa, 5 Mei 2015 10:55, "Dede [email protected] [belajar-excel]" <[email protected]> menulis: Dear Mr Toby dan para suhu lainnya, Telah saya pelajari ilmu yang kemarin Mr Toby berikan dengan sedikit modifikasi scriptnya. Masalah yang timbul adalah pada saat saya masukan kode barang di sheet “BS” cell A14, Kode tidak tampil di sheet “Pemusnahan BS”. Dimanakah letak kesalahannya yah?, mohon pencerahannya. Salam, DD _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
