Dear Andree,
Sebenarnya saya mau ikut nyoba cekriptnya, namun karena macro dan
filenya terprotect jadinya tidak bisa ;-)
Coba dicheck lagi email dari Mas Kid!
kalau bunyi formula ini dipasang dengan VBA, maka sebuah karakter "
(1 bijik karakter petik dua) harus diubah menjadi "" (2 bijik karakter
petik dua) :
cells_target.formula= *"**=text(alamat_cells,""0000;;""""
"""""")**"*
*
*
coba perhatikan cekrip ketikan anda:
TEXT(F1,""0000,,"""" """""")"
sudah tahu kesalahan anda?
Regard.
NangAgus
------------------------------------------------------------------------
Posted by: Andre Rahmaidy <[email protected]>
------------------------------------------------------------------------
Reply via web post
<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/45588;_ylc=X3oDMTJyazZiNTc4BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NTU4OARzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1NjM3Njg2ODU-?act=reply&messageNum=45588>
• Reply to sender
<mailto:[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20Trs%3A%20Fw%3A%20Macro%20Exel%20Convert%20ke%20TXT>
• Reply to group
<mailto:[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20Trs%3A%20Fw%3A%20Macro%20Exel%20Convert%20ke%20TXT>
• Start a New Topic
<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/newtopic;_ylc=X3oDMTJmNHN0NmVnBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNudHBjBHN0aW1lAzE1NjM3Njg2ODU->
• Messages in this topic
<https://groups.yahoo.com/neo/groups/belajar-excel/conversations/topics/45571;_ylc=X3oDMTM3OTRnNjN2BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NTU4OARzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzE1NjM3Njg2ODUEdHBjSWQDNDU1NzE->
(8)
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke:
[email protected]
posting ke milis, kirimkan ke: [email protected]
berkunjung ke web milis :
http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran :
http://www.mail-archive.com/[email protected]/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: [email protected]
keluar dari membership milis (UnSubscribe), kirim mail kosong ke :
[email protected]
---------------------------------------------------------------------
Visit Your Group
<https://groups.yahoo.com/neo/groups/belajar-excel/info;_ylc=X3oDMTJmMWd2cWhhBF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE1NjM3Njg2ODU->
Yahoo! Groups
<https://groups.yahoo.com/neo;_ylc=X3oDMTJlMTk3MXBuBF9TAzk3NDc2NTkwBGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTU2Mzc2ODY4NQ-->
• Privacy
<https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
Unsubscribe
<mailto:[email protected]?subject=Unsubscribe>
• Terms of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
SPONSORED LINKS
.
