Dear Syech,
Monggo, macro dari jeng ctv dulu..
Regards,
Rommy A
From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of Pujiono, Setyo
Sent: Sunday, April 27, 2014 6:25 AM
To: XL-mania@yahoogroups.com
Subject: ]] XL-mania [[ Refresh color - macro [1 Attachment]
Dear Excel Guru's
Sy coba untuk menghitung produk capacity dgn base color function dengan menambahkan macro dan ternyata berhasil. Namun ketika sy mengganti color di capacitynya, ternyata di perlukan satu macro unutk merefresh total colorfunction nya. Udah coba bikin macro, cuman hasil keluar dari area diimana cell yang di harapkan.
Option di excel untuk formula udah otomatis.
Mohon bantuan nya Gan, unutk create macro yang mana jika sy mengganti capacity color, refresh product output qty akan terhitung .
Thanks.
Best Regards,
Setyo Pujiono
Email : setyo.pujiono@philips.com
The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
| Maaf moderasi terlambat karena yahoogroups sering error |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário