Hi Paul, I appreciated that longer video format. It helped me locate where I'm at in my Excel VBA Array journey, and the clear explanations helped me to move to the next level. Nice tutorial; I'm a fan of your work!

Nice. What about Typescript for Excel ?

Thanks Paul - as always your videos contain very useful information. I like the longer content video above. It provides a more 'start to finish' approach to code logic. Best regards, Bill

Nice video but I have a feeling that you've covered this topic multiple times already in previous videos. As a long time fan of your content I consider myselft a master on arrays at this point :) I'd prefer more videos on Classes with some real world examples....

Thanks for sharing valuable information. I am already using array but it is still taking time to process big datasets. I have checked the number of iterations is more than 30+ million. Please can you tell me is there any way through which I can use GPU or multi-thread? I have done a lot of research regarding this and someone told me to use opencl but unable to find the library. I have tried to find some third-party tools also for parallel processing but I haven't found any tool yet. Please can you help me that would be great.

Thanks for your knowling

🙂_______👍💯 .

i didn't watch the video but i have a trick about array i don't know if you are aware of. its how to redim preserve an array's first dimension, we know that we can only redim the second dimenssion , so the trick is to fill your Array in reverse order what in first dimension go into the second and what in the second go into first dimension, so then you redim preserve the second dimension after that you transpost the array into a variant using worksheetfunction.transpose to get your initial copied range.

Hello Paul. I'm Kofi from Ghana. Please when will you make a VBA introductory video. It will be very much appreciated. Thank you

I have been utilizing your resources for 5+ years. I'm a stress engineer, so sifting through tons of raw data and outputting something useful with little individual input is the name of the game. Your stuff has been without question my favorite resource. Clear. Concise. Exactly what is needed.

Nice video, I'm working more with VBA nowadays and the knowledge I got from you helped me a lot, though I haven't adapted to not bubble up my variable declarations yet 😅

thanks Mr. Pau. Please, we need more videos with projects about real-time application in excel through websockt.

So more situations are incorrect. I have tested but not correct

Love this video! Do you program in Access VBA? Please would you do one for Access if you do? Thanks!

I like anything you do!

Paul, your tutorials are fundamental. Yes, I like them.

Let me know in the comments if you like this longer video format😀

I already knew these.

Sir if data is long or short Lastrow how to automatically select lastrow when generated PDF report ۔۔so how does it's work ۔۔

Awsum, thanks for taking the time to make these videos. They are so helpfull...

I’m crediting you with teaching me VBA. I think I’ve watched just about every video in this playlist over the past couple months. I do have a question. I regularly have to continually sum data with multiple conditions, frequently with Or criteria as well. Using excel formulas, I’d go for SUMPRODUCT. It doesn’t seem like the dictionary array would work for that because the key would have to be a combination of several attributes. Could you use the class module as the Key instead of the item?

Very useful and interesting, thank you Paul

absolutely brilliant. note that we can use Clear All to remove formating rather than having to close the whole WorkBook? :-)

Great tutorial! Wondering, is there a technical reason you use functions and arrays outside of the Userform to populate your combo boxes instead of Rowsource?

well... you can use conditional formatting instead. It's so simple... :D

Thanks for the code now it's up to me to learn and modify it for my need. Thanks again.

CTRL+C, CTRL+V. Next!

Thanks. Very didactic. Nerver thinked about using find this way. One cave at with find is hidden rows and hidden columns. If you have some of them find just seems to ignore them.

How to add additional workbook?

How to use xlwings in wsl system please give me a source code and instructions step by step , xlwings documentation in write xlwings server using Linux, wsl and Docker but not show how to use

Source code link doesn't work.

I struggled a bit to get this to work on an existing project, but I did it at the end! thank you so much, the work that you do is amazing

Dude - I've been writing VBA (mostly Access VBA) for years. Your videos have been an eye opener for me. I've basically went back and changed all of my "macros" and added your suggestions. My Excel macros now run much faster thanks to your suggestions. I'll make sure to watch your videos as much as I can. Again, THANKS!

That was quite impressive, Paul. I use your KZfaq site often for ideas, tips, and tricks.

My COBOL teacher hammered it into me to declare variables at the top. Possibly due to the nature of the declaration section

If data needs to be copied from a sheet which have blank cells due to which current region didn't work there. How we do that

Paul, please help me to make my code as faster you have shown here

Please ignore my request for help, I worked out the issue, I used the wrong sheet name.

Did someone pour hotwater on your balls, It does not hurt to speak slowly and clearly!

Great video. I am going to have to watch this at least one more time. There is a lot of information in this video.

I don’t understand for what create clsAccount? Just for information? Programming on vba for 4 years Your video very useful for me! Thank you Paul

Thanks so much. You are the best! I applied classes in my work.

ありがとうございます。VBA初学者としてとても勉強になりました

Hi, thanks for this, question, how would I force only xlsb when the user want to save as a file, I want the dialog picker or with 365 only show xlsb to show, this was possible before 365 but don't know how to do it in 365

I followed the ReadFromAPI() macro. I have the required tools. Nevertheless when I clicked on Debug the first time, after (minute 9:02) I already had the scripting runtime checked but got an error anyway. However, I went ahead and added the Jsononverter.ParseJson(request.Response.Text), I did not get a run time error. I then entered the remained of the code and clicked on debug. I got the error Run-time error 424 Object required. The debugger stopped on the Set countries = response("Country"). I can't determine the cause of this error. Can you help?

Thank you Paula for such useful videos, yes more

I finally get it. The other examples I've seen of this were only storing 1 data item per row in the collection (e.g. Name) so it wasn't clear why using a class was a benefit. Now that I see you can store multiple data items it makes sense. I guess if you were working with multiple classes you could store that as dimensions in an array?

One of my bugbears in life is processes that still involve the extraction of data from one system via pdf that some poor soul has to get into another system - amazing that this still happens in 2024! I have a specific use case where I used to use Able2extract to convert pdf to excel for monthly accounts. However, there was still a fair amount of manual processing to fix. Then my computer dies and I switch to an ARM based surface pro that cannot run Able2extract. So I find that Adobe has a reasonably priced pdf to excel that actually works better in that it maintains row integrity. Over to ChatGPT. I used a different process which was less structured. Rather than plan my code out in detail I was a bit lazy and had ChatGPT build it up step by step. In each iterations I found problems to do with either my specs or ChatGPT, but I just fed back the issues to chatGPT (eg. line of code causing error) and ChatGPT pu,mped out revised code. I think I halved my coding time and ended up with a very fast sub using arrays. Error resolution was far faster with ChatGPT. However, I did not add proper error trapping so the code probably does not meet commercial standards. ChatGPT is a far faster alternative than googling. I also like that ChatGPT forced me to define my problem unambiguously. Overall, I am astounded at what ChatGPT can do and I do think it is going to change the world of coding. I think productivity will increase dramatically in the coding business.

Thank you. This video helped me to solve my issue.

Awesome work!