This macro was posted in MrExcel some time ago and I found it on the internet in a search. I tried running it but it doesn't work. Any suggestions please?
Dim myList, myRange
Set myList = Sheets("Run Macros").Range("F1:G13") 'two column range...
Many years ago, I got hold of a macro to list file names in a folder and its sub folder. All worked flawlessly until work updated to Excel 2016.
The macro is no longer listed in the macro lists to use. It does use a private function to create the list that populates the spreadsheet.
Even if I...
This below code is helpful to get the data from json. but I am getting error at line "Set MyList = RetVal.Data" . The error is 'Object doesn't support this property or method'.
Note : I am able to extract all data from URL into object Retval when I can see all the details in Watches...