Thank you for the code, it is great and almost worked perfectly for me! I was able to use it to generate a list in a workbook A. It is a very small one, actually just some 10 lines and 5 columns.
Later on I programmed another workbook B to simply open the workbook A, go through all lines and import it. It is also a smart database. However, it often crushes after importing it and the "Out of memory" message appears. Sometimes it does not crush, then I go to VBA and try to open the Dictionary class module. When I do that the message Out of memory appears again. I can then do any other change in the rest of the project, but not this.
Weird thing, I don't know if it has happened to someone else. Restarted computer and the same issue happened again despite having almost no other programm opened.
Hi!
Thank you for the code, it is great and almost worked perfectly for me! I was able to use it to generate a list in a workbook A. It is a very small one, actually just some 10 lines and 5 columns.
Later on I programmed another workbook B to simply open the workbook A, go through all lines and import it. It is also a smart database. However, it often crushes after importing it and the "Out of memory" message appears. Sometimes it does not crush, then I go to VBA and try to open the Dictionary class module. When I do that the message Out of memory appears again. I can then do any other change in the rest of the project, but not this.
Weird thing, I don't know if it has happened to someone else. Restarted computer and the same issue happened again despite having almost no other programm opened.