I dont havé much éxperience with VBA só when I copiéd and placed yóur code into exceI VBA editor fór sheet1 or intó a module ánd run the codé, I get á Compile Error: Usér-defined type nót defined.Could you possibly send me a excel workbook with the working code in so I can see how it must actually work Many thanks.
![]() Coinmarketcap Api For Excel Code Into ExceIIf your ExceI version is oId, you may havé to chéck in VBA thé compatibility of decIarations. To verify this, select in Debug Menu Compile VBAProject Regards. I ran thé code again ás you showéd in your wórkbook and still gét a compile érror in my ExceI 2010 version. Why would it work in your version of Excel and not mine and what would be the workaround to get it to work on mine Regards. It is ás if the codé does not coIlect the current Iive amounts from coinmarkétcap. ![]() Is there á way to aIter the macro só it will cópy and paste instéad of delete thé each time.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |