Пікірлер

• 
  @Dexter101x11 сағат бұрын

  I don't mind the longer format, but would like shorter ones as well Is there something wrong with using xlDown as oppose to xlUp?

• 
  @karibeauchamp435817 сағат бұрын

  You have made this subject... So easy to follow. Absolutely FANTASTIC. THANK YOU SO MUCH!!!!

• 
  @Excelmacromastery22 сағат бұрын

  Learn how to write real-world Excel VBA code: 👉courses.excelmacromastery.com/ Want to download the source code for this video? Go here: shorturl.at/nMnc6 (Note: If the download page doesn't work then make sure to turn off any popup blockers)

• 
  @Excelmacromastery22 сағат бұрын

  Learn how to write real-world Excel VBA code: 👉courses.excelmacromastery.com/

• 
  @Excelmacromastery22 сағат бұрын

  Learn how to write real-world Excel VBA code: 👉courses.excelmacromastery.com/

• 
  @muhammadkausar2842Күн бұрын

  Really amazing work, yes we like it. I watched it 2 times 😂

• 
  @muhammadkausar2842Күн бұрын

  Hi Paul, you are amazing, i also download your ClsArray2D class module, and take so much benefits, thank you, now am also able to make my own function for arrays current region, or clear existing data,,. I also download this one , thank you so much for your free help😊

• 
  @sedataksakal414Күн бұрын

  You are amazing. Thank you. Greetings from Turkey.

• 
  @user-nj6em3lf9oКүн бұрын

  Hi Mr KELLY. Hope you're fine. I guess you've heard about Office script. My concern is to know if VBA is will still be used in the 5 or 10 next years?!!! Is Office Script is replacement!! I've got those worries since I read somewhere that Microsoft will definetively discard VBScript from Windows 11. Do you have clear and trustfull informations about that topic?

• 
  @ExcelmacromasteryКүн бұрын

  Office scripts a replacement for VBA. The VBScript update, as it stands now, will only affect regular expressions in VBA.

• 
  @dheerajjain5754Күн бұрын

  Can we use arrays to copy all file names from a folder and paste it in an excel range? I am currently using "Copy Path" menu item to copy all file names which are there in a folder and pasting them in excel because it is simpler and time saving than running a macro which reads each file one by one and copies its name.

• 
  @urielramirez272 күн бұрын

  Simply masterful! Do you have any courses or classes in recursive functions?

• 
  @ExcelmacromasteryКүн бұрын

  Thanks. I haven't covered recursion.

• 
  @urielramirez27Күн бұрын

  @@Excelmacromastery if you need an example idea for the course I have 2: getting the names of files in folders that have subfolders and getting the charges on a credit card charges history that sum up to the credit card current balance

• 
  @JOSELUISTORREZRIOS2 күн бұрын

  Excelente tutorial paso a paso y muy útil, muchas gracias

• 
  @iincitr2 күн бұрын

  Thank you again clean and valuable info. Any plan to video about Excel with Typescript or any other modern code?

• 
  @ExcelmacromasteryКүн бұрын

  I have videos on office scripts and Python on this channel.

• 
  @neronjp99092 күн бұрын

  Thx so much!! Great video

• 
  @neronjp99092 күн бұрын

  Thx so much!! Great video

• 
  @neronjp99092 күн бұрын

  Thx so much!! Great video

• 
  @Art81573 күн бұрын

  Paul, thanks for nice and detail comments. I have one question, why when I use "marks = shMarks.range("A1").Value" I receive error 424 (Object required). And it works when I write "marks = Sheets("shMarks").range("A1").Value".

• 
  @Excelmacromastery2 күн бұрын

  shMarks should be the code name of the worksheet

• 
  @alterchannel25013 күн бұрын

  i adore these types of videos

• 
  @Excelmacromastery2 күн бұрын

  Glad you like them

• 
  @alexandrumarcel36963 күн бұрын

  one issue I was facing when working with copying arrays is that if you have a column (or more) that is containing string values that starts with "0", the destination range needs to be formatted as text (.numberformat = "@"), otherwise the leading 0s will be truncated.

• 
  @home87713 күн бұрын

  does anyone know how to do "make a multiple line as comment" shortcut like the one in 14:35?

• 
  @Excelmacromastery3 күн бұрын

  See the second answer here: shorturl.at/HaQN1

• 
  @alializadeh81953 күн бұрын

  Thanx

• 
  @Excelmacromastery3 күн бұрын

  Welcome

• 
  @vipulDJhaveri3 күн бұрын

  Thanks Mr. Paul Great way to master , step by step - so basic fundamentals are very clear as we move forward with clutter free powerful codes - Your Mastery, always shared brilliantly to make us Masters as well ! Thanks a Lot for sharing your treasure 🙏

• 
  @Excelmacromastery3 күн бұрын

  Glad it was helpful!

• 
  @nathanbowers17613 күн бұрын

  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!

• 
  @Excelmacromastery3 күн бұрын

  Great to hear Nathan!

• 
  @Zboob9993 күн бұрын

  Nice. What about Typescript for Excel ?

• 
  @Excelmacromastery3 күн бұрын

  I have some videos on Office Scripts which using the TypeScript language for Excel.

• 
  @billroberts28083 күн бұрын

  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

• 
  @Excelmacromastery3 күн бұрын

  Thanks Bill

• 
  @schymi8413 күн бұрын

  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....

• 
  @Excelmacromastery3 күн бұрын

  Thanks. I have covered a lot of this before. However, this video shows a step by step logic from beginning to end.

• 
  @howitworks87493 күн бұрын

  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.

• 
  @suvadipkundu1522 күн бұрын

  Hi, would you like to elaborate on the problem statement a bit.. for example, would 30 million iterations mean that you are accessing data from multiple spreadsheets? What type of validations/logic are you processing? Can you employ 'divide and conquer' approach? Finally, have you looked at using Excel's ETL backbone, power query as a solution? I do not know the performance criteria you have so if you can throw some more light on the same that will help .. Cheers, Suvadip

• 
  @m_marcamo3 күн бұрын

  Thanks for your knowling

• 
  @Excelmacromastery3 күн бұрын

  You're welcome

• 
  @Fredick.73 күн бұрын

  🙂_______👍💯 .

• 
  @Excelmacromastery3 күн бұрын

  Thanks

• 
  @omaraissa3183 күн бұрын

  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.

• 
  @Excelmacromastery3 күн бұрын

  The problem is that Transpose has a limit of 64000 rows for arrays.

• 
  @omaraissa3183 күн бұрын

  @@Excelmacromastery thank you i learned something

• 
  @muhammadkausar2842Күн бұрын

  ​@@omaraissa318I have also the same problem, I use meta AI, but AI say, Copy this Array to new blank array and then resize it 😂 Thank u But still I am not completely understand of your comment I will screenshot it 😊

• 
  @vbaclasses35533 күн бұрын

  Amazing video as always Paul. The longer format is quite good as well. Thanks.

• 
  @Excelmacromastery2 күн бұрын

  Thanks

• 
  @kofigyebiadusei22053 күн бұрын

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

• 
  @sevencrickets92583 күн бұрын

  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.

• 
  @Excelmacromastery3 күн бұрын

  Glad you like it so much😀

• 
  @danielmelo3893 күн бұрын

  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 😅

• 
  @Excelmacromastery3 күн бұрын

  Thanks Daniel

• 
  @hammeedabdo.823 күн бұрын

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

• 
  @tunguyenthanh97233 күн бұрын

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

• 
  @daveyks13 күн бұрын

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

• 
  @Excelmacromastery3 күн бұрын

  Glad you like it. I haven't used Access in a long time .

• 
  @dangreen25013 күн бұрын

  I like anything you do!

• 
  @Excelmacromastery3 күн бұрын

  Thanks 😊

• 
  @SolutionsByPVV3 күн бұрын

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

• 
  @Excelmacromastery3 күн бұрын

  Thanks

• 
  @Excelmacromastery3 күн бұрын

  Learn how to write real-world Excel VBA code: 👉courses.excelmacromastery.com/ Let me know in the comments if you like this longer video format😀

• 
  @mariustapculescu10613 күн бұрын

  Yes is beautifull ,easy to follow you and learn a lot!

• 
  @clandeszipp45644 күн бұрын

  I already knew these.

• 
  @malcolmt31255 күн бұрын

  This is really good as a learning curve but, trying to implement it into my own workbook ! My data is not starting at A1, but C5, I can only see the reference on this line on the code added from your readme file " frm.ListData = Sheet1.Range("A1").CurrentRegion " changing this A1 location address does not point to my data, if I add sample data to say B1 or C1 I can get it to see it but not on a line 5 start.

• 
  @muhammadhanifsoomro31667 күн бұрын

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

• 
  @stevec18357 күн бұрын

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

• 
  @MattyG5407 күн бұрын

  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?

• 
  @Excelmacromastery3 күн бұрын

  If you have multi criteria then you can use multiple fields as the key. Concatenate them together as a string. You wouldn't usethe class module as a key as this would mean the key was a memory address.

• 
  @cesarbravo10359 күн бұрын

  Very useful and interesting, thank you Paul

• 
  @edrobinson824810 күн бұрын

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

• 
  @justinwduff11 күн бұрын

  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?

• 
  @CANDEEIRO12 күн бұрын

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

• 
  @connectorservice376712 күн бұрын

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