naah... mungkin typo yang dijelaskan mas Nang tersebut pemicu error-nya...
On Mon, Jul 22, 2019 at 3:50 PM Agus [email protected] [belajar-excel] < [email protected]> 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 <[email protected]> > <[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 > <[email protected]?subject=Re%3A%20%5Bbelajar-excel%5D%20Trs%3A%20Fw%3A%20Macro%20Exel%20Convert%20ke%20TXT> > • Reply to group > <[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) > . > > > >
