top of page

A little late, but I've just added another video to my YouTube channel!

At the best of times, I'm not sure what day it is (no concept of time, ask anyone who knows me :)) Anyway, I meant to post this on Sunday, but turns out it's now Tuesday, so...


...I've added another free video to my YouTube channel...



If you like this video, please hit the subscribe button!


This is a lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming), which will teach you everything you will ever need to know about coding in VBA.


All the code is there on the screen for anyone to use, free, gratis, and for no charge :) Though I hope it will guide some of you to get the course...you should, it's really useful.


So, this is another SQA (Student Questions Answered) lecture, this one from Pascal...and it's a great one...


A very simple problem, and a very easy solution. Imagine the scenario...you have a workbook with hundreds of sheets, and you want to find a specific value, the name of a sales person for example...you suspect it's in one of those sheets, but which one? What if there's a thousand sheets, and it's in sheet number 999, or worse yet, it's not in any of them! It could take hours using CTRL+F on each and every sheet, but if we automate that process with a bit of code, we can do it in seconds...much more efficient, I think you'll agree :)


So, all the code is here, and a complete walkthrough of how it works.


Enjoy!


Be sure to check out the other videos on the channel...there are quite a few!


Videos in the Level 1 series:



Videos in the Level 2 series:



Videos in the Level 3 series:



 
 
 

Comments


Purchase: Super Memory Essentials, Leadership and Management Essentials, and The Complete Excel Series (including Levels 1, 2 and 3) are available for purchase via the Udemy platform...just click " Buy Now..." or "Purchase Lifetime Access..."button and your special discount will be applied automatically. This option give you lifetime access, and is backed by the Udemy full 100% money back guarantee. So, if you're not entirely happy, you can get all of your money back, no questions asked.

All Courses are also available to UK students via https://www.reed.co.uk/courses/?keywords=alan%20jarvis

That sounds good, right? I thought so. So, choose your path to learning, and I'll see you in the course(s).

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon
  • YouTube

© 2023 by Personal Life Coach. Proudly created with Wix.com

bottom of page