naah... mungkin typo yang dijelaskan mas Nang tersebut pemicu error-nya...
On Mon, Jul 22, 2019 at 3:50 PM Agus nanga...@gmail.com [belajar-excel] < belajar-excel@yahoogroups.com> wrote: > > > 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 <andree_bpdsum...@yahoo.co.id> > <andree_bpdsum...@yahoo.co.id> > ------------------------------ > Reply via web post > <https://groups.yahoo.com/neo/groups/belajar-excel/conversations/messages/45588;_ylc=X3oDMTJyazZiNTc4BF9TAzk3MzU5NzE0BGdycElkAzIwNjI3Njc4BGdycHNwSWQDMTcwODI5ODgyMQRtc2dJZAM0NTU4OARzZWMDZnRyBHNsawNycGx5BHN0aW1lAzE1NjM3Njg2ODU-?act=reply&messageNum=45588> > • Reply to sender > <andree_bpdsum...@yahoo.co.id?subject=Re%3A%20%5Bbelajar-excel%5D%20Trs%3A%20Fw%3A%20Macro%20Exel%20Convert%20ke%20TXT> > • Reply to group > <belajar-excel@yahoogroups.com?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) > . > > > >